Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Help, my database is corrupt. Now what? RE: Help, my database is corrupt. Now what?

  • February 17, 2009 at 5:29 am

    #945096

    GilaMonster (2/17/2009)

    Jeff Moden (2/16/2009)

    How much of this applies to the system's databases (not including TempDB, of course)?

    MSDB can be repaired, I believe (haven't tried it). Master I would recommend restore or rebuild, though I have seen someone repair it successfully. Model, since it should have nothing in it, you should be able to copy from another server.

    Depends what the corruption is. If it's just in the nonclusters, then repair's probably safe even in the system databases. If it's in the clustered index then my recommendation would be restore or rebuild (especially with master)

    Master and msdb can be completely recreated, by the rebuild master function of the installer (master) or by script (msdb). It won't get any data back, but it will get the DB usable and free of corruption.

    That begs this question... assuming you have a corrupt backup of msdb, can you rebuild it then reimport the data back in?