January 31, 2005 at 12:28 pm
I was hoping to find someone that has experienced a similar scenario that can offer some advice. I had a user enter a record in a table a little before 1 PM and accidentally deleted a few minutes later. They entered a lot of text into some fields and asked me if I could recover it. I thought maybe I could since I have the transaction logs backing up every hour. Unfortunately when I went to look at the transaction logs the last one there was for 10 AM and they deleted their data a little after 1 PM. I believe I have resolved why the transaction logs stopped backing up, but I am wondering can I recover their record they deleted? Any help or advice would be appreciated. thanks
Keith
January 31, 2005 at 1:31 pm
Yes,
Take a current transaction log backup that contains all of the transations between 10am and the time you want to restore to. Then perform a point-in-time restore up to the exact time you want.
You'll need to restore the last full database backup with no-recovery and then restore the transaction log with a stopat parameter.
RESTORE DATABASE <dbname> FROM DISK=<filename> WITH NORECOVERY
then
RESTORE LOG <dbname> FROM DISK=<filename> WITH STOPAT='datetime'
for more info look at the point in time restore in BOL.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply