Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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')?

share|improve this question
Please clarify, which Database Management System you use? – Oleg Tsarev Aug 8 '12 at 16:34

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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