Post reply

My DataBase Went to RECOVERY_PENDING State

  • August 19, 2011 at 7:06 am

    #255894

    Dear All,

    My database went to Recovery_pending state.. I can't access that database.... I created DB diagrams In that Database.. Now I can't access that DB... I tried some steps to set it for ONLINE...

    Queries I used...

    1) SELECT name, state_desc FROM sys.databases where name = 'MydatabaseName'

    2) SELECT DATABASEPROPERTY('MCPS50NEW','ISSHUTDOWN') -- It showing '1'

    3) ALTER DATABASE DB_NAME SET OFFLINE

    4) ALTER DATABASE DB_NAME SET ONLINE

    When I am trying with 3 & 4 steps it throwing error's

    can anybody Please help me out

    Regards,

    SqlSpider:-)

  • August 19, 2011 at 7:10 am

    #1370695

    Check the sql err logs for the exact error and post it here.

    As Gail says, it's often because the log file is gone. Best thing is to put it back. But we'll see from you real error.

  • August 19, 2011 at 7:48 am

    #1370730

    That state comes from a file missing or inaccessible. Find all the messages in the SQL error log relating to this database and don't try anything to it just yet (especially DO NOT detach it)

    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