Post reply

Sql 2005 database restore

  • January 5, 2010 at 1:38 pm

    #1099214

    Yes. The 7 AM Tuesday T-Log backup contains all transactions logged since the last T-Log backup Monday night.

  • January 5, 2010 at 1:57 pm

    #1099236

    Providing there was no switch to simple recovery between 5pm and the full backup at 11, yes.

    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

  • January 5, 2010 at 2:19 pm

    #1099240

    If you restore 7 am log with STOP AT option you may loose the other transactions which you may no need to rollback or loose them...

    It depends on the what type of mistake how much data loss can the company can efford...

    Another option would be restore on to a different server 11 pm previous day full backup and restore 7 am t log backup with STOP AT option and copy the data/tables as needed...but as said it all depends on the problem....how worst it is...

    MohammedU
    Microsoft SQL Server MVP

  • January 6, 2010 at 10:23 am

    #1099751

    Thanks.

    We just need to restore the database back to 6:59PM. any data loss after 6:59 will be ok.

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

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