Post reply

When to Restore and When to Rebuild master database

  • May 11, 2014 at 6:34 am

    #307670

    Hi,

    If one is regularly taking backups of system databases, when does it become necessary to rebuild the master database. I am looking for a situation where rebuilding the master is preferred to restoring it from backup.

    Thanks !

  • May 11, 2014 at 8:54 am

    #1712477

    It's not a case of which you do. If you have backups you'd almost always want to restore. There are scenarios however where you'd need to rebuild first to get SQL up and running and then restore.

    This may be of interest: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    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

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

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