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 |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2005-09-22 : 10:11:52
|
| Hello all,I want to move all databases to a different server. I know how to do it on a single database. My question is , which one i have to restore first? the master database or user databasesThanks for your helps. |
|
|
Sharky
Starting Member
23 Posts |
Posted - 2005-09-22 : 10:22:58
|
| I would do the system databases first, then let the sql restore maintain them when the user databases are restored. You can also just detach all the databases and move the files to the new server and attach them again. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2005-09-22 : 10:55:10
|
| Thanks for your suggestion. Appreciate them. |
|
|
|
|
|
|
Backup & Restore Question