• Draconian (7/24/2014)


    My Production database is in Recovery pending status. I checked and found due to Hard disk space it went into suspect mode.

    Suspect or Recovery_Pending? They're two very different statuses. Query sys.databases and please see exactly what the status_desc column is for that database.

    Open the error log. There will likely be several errors relating to that database. Please post every message relating to that database, whether you think it relevant or not.

    Do you have backups of this database?

    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