August 30, 2007 at 5:06 am
Hi,
I have my backup scheduled as shown below
at 9.00am -- full backup
at 9.15am - Transaction log backup
at 9.30am - Transaction log backup
Suppose at 9.20am(say) the user deletes a table and i want to restore that particular table,i will use STOPAT clause when im restoring the transaction backup at 9.30am (WITH RECOVERY).But my doubt is how to find out the exact time the user has deleted the table.I have even checked the SQLServer Error log file but it doesnt give the exact date and time stamp of the deletion activity tht has taken place so that i can use that in STOPAT clause of RESTORE LOG command.
Please tell me where should i look for date and timestamp for all the Deletions/Updations done on a particular database.
Thanks in advance.
Regards
Arvind L
August 30, 2007 at 6:11 am
Arvind,
unless you have some transaction log reader utility like LogExplorer you can't find the exact time. So you can either go with the trial and error method or restore the backup into a new database and when copy the table.
Hope this helps
Markus
[font="Verdana"]Markus Bohse[/font]
August 31, 2007 at 7:39 am
Best option is LogExplorer. Its easy and painless.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply