I need to look at the contents of sysdatabases from an older backup of master, but I do not want to overwrite my master databse. Can I use the rename option of the restore command to restore master as something else ('MyDB')?
Asked
Active
Viewed 1,558 times
1 Answers
2
Yes, as long as you are restoring it to a server instance that is the same build number that it came from originally you should be fine. If you try to restore a system database on an instance with different build number it will fail.
squillman
- 37,618
- 10
- 90
- 145