Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    California
    Posts
    18

    Smile Unanswered: What will be a good way to backup master db?

    Currently, I have set up maintenance plan to backup all the databases and I am only the most recent copies. This works very good for me on most of the databases. However, I am having a potential problem with backing up master database.

    Based on what I know, I cannot perform a restore on master database. So I am wondering if anyone is able to advise me on a good method to backup the master database and restore it when it needs to be.

    Thank you.

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You know incorrectly. You have to start the instance of SQL Server in single user mode. You can then restore the master database. Look at startup option in Books Online.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •