question about restoring to a specific transaction

  • Hi.

    I can do a db restore from db backup, then differential, then logs. what i would like to know is this:

    Lets say i have a transaction :

    Begin Transaction
    drop table ReallyImportantTable
    Commit Transaction

    I dont realise this has been done for an hour or so and many other transactions have been commited since.

    How,after restoring all backups, do i restore the db to the commited transaction just before the table drop? or even restor to a specific point in time, in the middle of transaction log backup or tail backup?

  • What I'd do is restore the db and the tran logs to another server. Use STOP AT to stop the restore just before the bad transaction started, then copy the table that was dropped back to the main database.

    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