Would it be possible rollback transactions using Transactionlog file for a particular record? I am using MS SQL 2005.
+4
A:
Natively, no. I believe there are some pricey third party tools to do this, though.
Alternatively, you can restore your DB from a backup, and then RESTORE LOGS to a point in time with the STOPAT = '6/30/2009 2:30PM' argument.
There are Apex and SQL Log Rescue available. If your logs aren't in FULL recovery mode, though, you may be up a creek if you can't restore.
Eric
2009-06-30 19:30:04
Can you give me a sample of these tools please?
THEn
2009-06-30 19:32:09
The recommended way is to restore a copy of the database with STOPAT and then copy over the data from the copy into the real database.
Remus Rusanu
2009-06-30 19:42:48
+2
A:
Check out RedGate's LogRescue product. Without 3rd party products, you're probably limited to doing a point in time restore to a separate database and then manually copying the record back to your production database.
Scott Ivey
2009-06-30 19:34:24
According to its webpage, LogRescue is limited to SQL Server 2000 only
Samuel Jack
2010-08-09 13:49:06