sql server - Rollback transaction using transaction log

Question

Would it be possible rollback transactions using Transactionlog file for a particular record?

I am using SQL Server 2005.

Answer 1

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.