Post reply

Restore after Disaster

  • March 2, 2010 at 10:44 pm

    #141638

    Hi all ,

    I want to restore Point in time Recovery,but the challenge is i have last transaction backup after that backup within ten minutes server get into disaster .Is that possible to restore that ten minutes log too?

  • March 2, 2010 at 10:52 pm

    #1127538

    Maybe, depends what kind of disaster. If the server is still up and SQL is still running and the log for that database is still available, you should be able to a tail-log backup (backup log with no_truncate)

    If the log isn't available, then those 10 minutes of data are lost.

    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

  • March 2, 2010 at 11:04 pm

    #1127541

    Thanx gail

  • March 3, 2010 at 12:43 am

    #1127563

    Just to add to gail's points

    You can also take the tail log backup if master DB is corrupted but ldf file of the user DB is still available.

    checkout this article: Here

    open to suggestions

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek

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

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