Database stuck in RECOVERY_PENDING state

  • Hi,

    I have client who sql express installation hosting search database for sharepoint search. they informed yesterday that search not working and I found the search database in SUSPECT state.

    I tried put the database in Emergency mode and then to Single User mode in order to run

    ALTER DATABASE dbname SET EMERGENCY

    GO

    ALTER DATABASE dbname SET SINGLE_USER

    GO

    DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS)

    but I'm getting the message

    ''dbname is being recovered. wait until recovery is finished"

    This yesterday afternoon, even after 16 hours , I'm getting same message. I tried the restarting SQL services but didn't help

    it complaining the corruption is in .mdf file which 300mb in size and Log is 8Gb in size

    They don't have any backups 🙁

    Thanks in Advance

  • This was removed by the editor as SPAM

  • As you said you don't have any backups it seems to me the issue of mdf corruption. You should go for any third party tool, try Recoveryfix for SQL Database software hope this helps for you.

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

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