Database suspect.

  • After the server restart , one of the database is not coming online. any help to resolve

  • Database might be went in recovery pending state. check the error log as well for more information.

  • Satya_0000 (3/17/2012)


    After the server restart , one of the database is not coming online. any help to resolve

    Put the database into emergency mode and run dbcc checkdb, post back the results.

    Also, what is the recovery model of the database, do you have recent backups?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Before you do anything...

    What is the exact state of the database (check state_desc in sys.databases)

    What error message are there for the DB in the SQL error log?

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

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