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 |
|
juancabrera
Starting Member
30 Posts |
 Posted - 2009-04-23 : 14:32:26
|
| I have restored master databases on the same box before. However, I am trying to restore to our Disaster Recovery box. This box has a different server name, would this generate a problem when trying to restore the master database? Does the master database contain server name or specific server information? For instance, certificate information? I wouldn't think so, but I want to make sure before I start building our DR environment. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
juancabrera
Starting Member
30 Posts |
Posted - 2009-04-23 : 16:53:10
|
| tkizer,Thanks for your reply. I have managed to restore the master db in the past even if the paths were not the same using sql cmd. I just had to alter the system databases and modify their paths, as well remember to do the systemresources db which is new in 2005. I just have not done this on a box that has a different name, but I was just curious of that mattered. Thanks for your input. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Master Database Restore