3

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
  • 2
    Please clarify, which Database Management System you use? Aug 8, 2012 at 16:34

1 Answer 1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.