Post reply

suspect mode

  • April 18, 2012 at 1:25 am

    #267725

    hi all,

    please help me to how to recover database from suspect mode without lose of data.i am scared to run the query which is get from some sql sites.please help me!!!!!!

    thanks

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

    I am Learner -- SQL

  • April 18, 2012 at 1:52 am

    #1475187

    If the DB was in full recovery model, first try to take a tail-log backup. Once that's done restore from your last good backups. Restore all log backups in sequence, restore the tail log backup you just took.

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

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