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')?
1
-
2Please clarify, which Database Management System you use?– Oleg TsarevAug 8, 2012 at 16:34
Add a comment
|
1 Answer
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.
answered Aug 8, 2012 at 16:51
