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.
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 |
 |
|
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. |
 |
|
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 |
 |
|
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. |
 |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-14 : 23:24:15
|
That's correct. |
 |
|
|
|
|
|
|