Post reply

Database --- Gone Suspect Mode

  • August 4, 2011 at 8:16 am

    #255165

    Hi All,

    While working on something , platform /windows team has un-mounted 5 drives ( which were containing the secondary data files for one of my database ), without taking the database to offline state .

    Now , the database has gone to suspect mode and we cant perform any operations on it .

    Is it something we can do now providing we dont have any backups for that particular database ?

    Thanks in advance .

  • August 4, 2011 at 8:36 am

    #1363689

    Restore from backup.

    Oh, wait...

    Short answer, you're probably screwed. To be sure, check the SQL error logs and post ALL the messages that relate to that DB. Need to know exactly why SQL marked that database as suspect.

    DO NOT detach.

    DO NOT restart SQL

    DO NOT try any other repair 'techniques' that you may find or people may post here until the reason for the suspect state is known

    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

  • August 4, 2011 at 8:37 am

    #1363690

    Actually, ignore most of that for now. Can the windows team re-mount those drives? Or are they gone for good?

    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 3 posts - 1 through 2 (of 2 total)

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