|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Upgrade hardware - WINNT vs Windowscurrent sql server o/s is Windows 2003 with a system root of c:\winnt. The new windows 2003 system root (By default) is c:\windows. I plan on doing a move of the sql server via the notes from the link below. http://vyaskn.tripod.com/moving_sql_server.htm My question is: Do I have to use the same system root on the new box as the old or doesn't this matter? -- Paul Bergson MVP - Directory Services MCT, MCSE, MCSA, Security+, BS CSci 2003, 2000 (Early Achiever), NT http://www.pbbergs.com Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights. It doesn't matter. The upgrade/install process will detect the system
drive\folder. -- Show quoteHide quoteHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Paul Bergson [MVP-DS]" <pbergson@allete_nospam.com> wrote in message news:uZ8XbXr8GHA.1012@TK2MSFTNGP05.phx.gbl... > I'm in the process of upgrading my hardware on my sql 2000 server. The > current sql server o/s is Windows 2003 with a system root of c:\winnt. > The new windows 2003 system root (By default) is c:\windows. > > I plan on doing a move of the sql server via the notes from the link > below. > > http://vyaskn.tripod.com/moving_sql_server.htm > > My question is: > Do I have to use the same system root on the new box as the old or doesn't > this matter? > > -- > Paul Bergson > MVP - Directory Services > MCT, MCSE, MCSA, Security+, BS CSci > 2003, 2000 (Early Achiever), NT > > http://www.pbbergs.com > > Please no e-mails, any questions should be posted in the NewsGroup > This posting is provided "AS IS" with no warranties, and confers no > rights. > > My question relates to when I move the db's from the old server to the new
server. Will sql server need to have the system root reside in the same location when I move master, model, temp, etc... -- Show quoteHide quotePaul Bergson MVP - Directory Services MCT, MCSE, MCSA, Security+, BS CSci 2003, 2000 (Early Achiever), NT http://www.pbbergs.com Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights. "Hilary Cotter" <hilary.cot***@gmail.com> wrote in message news:uAzHber8GHA.4408@TK2MSFTNGP02.phx.gbl... > It doesn't matter. The upgrade/install process will detect the system > drive\folder. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Paul Bergson [MVP-DS]" <pbergson@allete_nospam.com> wrote in message > news:uZ8XbXr8GHA.1012@TK2MSFTNGP05.phx.gbl... >> I'm in the process of upgrading my hardware on my sql 2000 server. The >> current sql server o/s is Windows 2003 with a system root of c:\winnt. >> The new windows 2003 system root (By default) is c:\windows. >> >> I plan on doing a move of the sql server via the notes from the link >> below. >> >> http://vyaskn.tripod.com/moving_sql_server.htm >> >> My question is: >> Do I have to use the same system root on the new box as the old or >> doesn't this matter? >> >> -- >> Paul Bergson >> MVP - Directory Services >> MCT, MCSE, MCSA, Security+, BS CSci >> 2003, 2000 (Early Achiever), NT >> >> http://www.pbbergs.com >> >> Please no e-mails, any questions should be posted in the NewsGroup >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> > >
Rebuild Index
checkpoint process and flushing pages ASP query to SQL db Memory - PAE, AWE, /3GB Upgrade from 2000 to 2005 Need Advice on Reporting, End User Query and Data warehousing Tools Problems when performing RESTORE DATABASE on Windows XP Mediacenter with Intel Core Duo import an excel file Cannot start up local server Increasing Storage in SQL Server 2005 Express |
|||||||||||||||||||||||