Suspect Database

  • We recently had some kind of error on one of the server's hard drives, that made the drive "disappear". The network guys, reinintialized (or something) and were able to bring everything back in an hour or so.

    However, one of my databases now is "Suspect" and can't be used. Both the MDF & LDF exist, and there are no indications of actual data loss.

    What can I do with a "suspect" database ?

    SQL 2K SP2

  • Look up on BOL for

    sp_resetstatus & DBCC DBRECOVER (database)

    If it aint broke don't fix it!


    Andy.

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

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