Post reply

Rebuild master database

  • June 2, 2008 at 11:24 pm

    #75225

    If master database is corrupted we can restore through rebuild.exe. Is it necessary to restore all other system databases too after rebuilding master database?

    [font="Comic Sans MS"]Sara[/font]

    A ship in the harbour is safe . . . but that's not what ships were made for. 😀

  • June 3, 2008 at 2:21 am

    #823456

    Yes. The MSDB and Model DB needs to be restored from the back ups.

    Renuka__

    [font="Verdana"]Renuka__[/font]

  • June 3, 2008 at 2:31 am

    #823464

    Thanks very much...is it not required to restore tempdb database?

    [font="Comic Sans MS"]Sara[/font]

    A ship in the harbour is safe . . . but that's not what ships were made for. 😀

  • June 3, 2008 at 7:00 am

    #823574

    There is no need to restore the tempdb database as it is re-created every time the SQL Server instance starts.

    http://msdn.microsoft.com/en-us/library/ms190768.aspx

    Kyle

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

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