Post reply

SQL server Master Database restore

  • November 20, 2005 at 8:14 pm

    #111515

    Hi All,

    Can anyone help me, I have backedup my master database lastweek, and now I want to restore it back now. Will there be any problem?

    Anyone tell what is the core role of master database in sql server2000?

  • November 21, 2005 at 12:34 am

    #604863

    First, may I suggest you post in a more appropriate forum, like SQL Administration or SQL General. This forum is for discussion of the site's question of the Day, not general SQL questions.

    That said, search books online for information on how to restore Master. (index -> restoring databases -> master database). It's not as simple as it may sound

    The master database stores all the information about the server. Logins, linked servers, databases, etc, etc.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 23, 2005 at 9:09 am

    #605483

    Yeah - like Gail suggests above - understand what a master db or other system dbs are used.  Restoring a Master DB is not like restoring non-system dbs.    You need to be in single user mode - Stop MSSQLServer and SQLServerAgent services. From a command prompt, enter this command to put start in Single user mode sqlservr.exe -m

    Run Enterprise Manager to restore the master database from the backup.

  • November 25, 2005 at 2:59 am

    #605810

    Thanks a lot. After restoring master database my sql server running like "charm"...

    thank u

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply