Home Forums Article Discussions Article Discussions by Author Discuss content posted by UTSAB CHATTOPADHYAY A guide to recover a database out from Suspect mode RE: A guide to recover a database out from Suspect mode

  • February 10, 2010 at 8:04 am

    #1116842

    Vee (2/10/2010)

    i believe it should be

    RESTORE DATABASE <suspecteddatabasename> WITH RECOVERY

    Yes, however that does not fix a suspect database. It brings a database that's in the RESTORING... state Online.

    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