How to Restore Master without Single User Mode

After doing a recent disaster recovery test, I decided to do things differently when restoring a SQL Server from scratch.  Hope this helps some of you out.

This still requires a restart btw, but may be quicker/easier depending on what you are trying to accomplish.

Simply restore the Master database to a new database with new MDF and LDF files.  You can then stop the SQL Server service, copy the original database files off for safe keeping and then replace the clean ones with the new ones.  Example….

Normally you restore Master.BAK a database called Master and to files named Master.MDF and Mastlog.LDF  Instead do the following.

  1. Instead restore to  a database named Master2 and files name Master2.MDF and Mastlog2.LDF.
  2. Turn off SQL Server
  3. Rename Master.MDF to Master0.MDF
  4. Rename Mastlog.MDF to Mastlog0.MDF
  5. Rename Master2.MDF to Master.MDF
  6. Rename Mastlog2.LDF to Mastlog.MDF
  7. Turn SQL Server back on.

This is a good way to restore the master database with the least amount of downtime.  Some people might want to do the following with the Master and MSDB database to hit the ground running with restoring all the other databases in case of recovering from a server loss or just testing your disaster recovery scenario.

2 thoughts on “How to Restore Master without Single User Mode”

  1. Other Icaros call the spirit of Ayahuasca to open visions
    as though exposing the optic nerve to light’. If I had those two
    in my life, I settled much faster and I felt happy.
    And the drink didn’t just help Sam, but all his friends to the best of my knowledge: an arthritic Rottweiler,
    a cat with cystitis and a dog with digestive problems, just
    to name the first three who tried the aloe drink. The hundreds of people were tested to find the human energy vibration was raised,
    the energy increased. It dissolves simultaneously with
    the physical body.

  2. Good day I am so thrilled I found your weblog, I really found you by accident, while I was
    looking on Digg for something else, Regardless I am here now
    and would just like to say thanks for a tremendous post and a all
    round exciting blog (I also love the theme/design), I don’t have
    time to read it all at the minute but I have bookmarked it and
    also included your RSS feeds, so when I have
    time I will be back to read more, Please do keep up the great job.

Leave a Reply

Your email address will not be published. Required fields are marked *

two + 8 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>