Post reply

What is point of Recovery?

  • November 19, 2007 at 12:40 am

    #122450

    What is point of recovery? If i am using full recovery model, if my database corrupted after my last transaction dump what is the immediate step should i follow?

    thanks in advance

    vyas

  • November 19, 2007 at 1:17 am

    #752156

    Backup the tail of the transaction log (backup log to file="..." with NORECOVERY, NO_TRUNCATE)

    Restore your full DB backup with no recovery.

    Restore your Diff backup with no recovery (if applicable)

    Restore all your tran logs backups, in sequence, all with no recovery

    Restore the backup you made of the tail of the log, with recovery

    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

  • November 19, 2007 at 2:15 am

    #752166

    Use STOPAT clause in the RESTORE statement to restore to a point in time.

  • November 19, 2007 at 7:44 am

    #752287

    Recovery is the process of rolling forward and rolling back when a database starts. It is different from the recovery model. The advice above (both) is what you would follow for RESTORE, not recovery.

  • November 19, 2007 at 8:22 am

    #752307

    Thanks Steve, for the information about recovery.

Viewing 5 posts - 1 through 5 (of 5 total)

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