Post reply

Master correpted

  • October 19, 2006 at 6:25 pm

    #121002

    Hi,

    SQL server (2005) service is not starting, error message is master corrupted, I have good backup copy, is there any way to restore master database using my backup copy?.

    Thanks in advance.

    RS.

  • October 20, 2006 at 3:49 am

    #667001

    As long as SQL server service is not starting you cannot restore the backup. So you will need to rebuild the system database. See BOL for the exact syntax.

    Be aware that in SQL 2005 all system databases are rebuild, not just the master. So any jobs, maintenance plans SSIS packages etc. in the msdb need to be restored from a backup.

    Hope this helps

    Markus 

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

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