Post reply

Point in time recovery - tlogs

  • October 18, 2005 at 10:00 pm

    #110229

    I recently had to recover a database using transaction log backups.  A long story short a developer updated a bunch of data in prod thinking he was in development.  ( I know- I know why does he have access to prod... I didn't give him access)

    I was able to recover the database to a point in time i.e. just before he ran the update statement.   All is fine now however: 

    Let's say that I didn't realize that he corrupted the data until a day later... how would you recover from that?  how could you recover all the transactions after the update statement?

     

    Thanks

  • October 19, 2005 at 6:58 am

    #598206

    You have to redo the transactions that after the update statement manually, i.e. re-enter /modify the data from your client app.

     

  • October 19, 2005 at 8:07 am

    #598263

    One way.....Restore the database to the point in time prior to the problem. Then restore the database again to another location (instance or dbname), then figure out what is different in the second version and copy those into the original database.

    -SQLBill

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

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