Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring system databases

Author  Topic 

rushdib
Yak Posting Veteran

93 Posts

Posted - 2007-05-12 : 14:42:27
Hi,
We are looking ahead in migrating our sql server 2000 to a new box. Can you please provide me the steps on restoring master, model, msdb, distribution databases from backups? Still I am not sure the server name or directory structure will change or not. If this changes, what modifications do I need after restoring?
Just from a curisity point of view if the server name and directory structure will remain same, can I replace the system database files on the new server using the files from the old server by stopping the sql service?

Thanks in advance,

Rushdi

Kristen
Test

22859 Posts

Posted - 2007-05-12 : 14:48:30
"Just from a curisity point of view if the server name and directory structure will remain same, can I replace the system database files on the new server using the files from the old server by stopping the sql service?"

In general yes. And as long as you copy the original files, on the new server, before you overwrite hem you can easily get back to where you were anyway.

Kristen
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-12 : 18:40:49
Ensure new server has same version number as old one's.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-05-13 : 07:19:22
... or patch old one to be the same as the new one, before cutting over the files.

Kristen
Go to Top of Page

rushdib
Yak Posting Veteran

93 Posts

Posted - 2007-05-14 : 16:54:21
If the server name is different, will this method still work? I know I have to change the server name in sysjobs and sysservers after moving the files.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-14 : 23:24:15
That's correct.
Go to Top of Page
   

- Advertisement -