Post reply

MASTER DB corrupted, what will you do???

  • November 26, 2005 at 5:40 am

    #95952

    Hi Folks,

    the MASTER system db itself corrupted, how

    will you restore the database?

    Pls help.

     

    THANKS

    JK.

    Thanks
    Jay
    http://www.sqldbops.com

  • November 26, 2005 at 5:57 am

    #605947

    1) Copy msdb and model databases to a safe location (assuming they aren't corrupted) because otherwise they will get overwritten..

    2) Copy "starter" system databases off of the SQL Server CD onto the computer.

    3) Untoggle Read Only flag on the starter system database files.

    4) Run rebuildm.exe

    5) Restore master database from a backup.

    6) Stop SQL Server (if it's running).

    7) Copy back msdb and model databases.

    K. Brian Kelley
    @kbriankelley

  • November 26, 2005 at 6:01 am

    #605949

    So Happy, Thanks Kelley.

    JK.

     

    Thanks
    Jay
    http://www.sqldbops.com

  • November 26, 2005 at 6:05 am

    #605950

    One other thing. After rebuildm, stop the SQL Server service and start it back up locally in single user mode... That'll ensure no users try to connect as you try to restore the master db.

    K. Brian Kelley
    @kbriankelley

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

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