SQL Server 2008 RC2 Edit transaction Log I have been handed an issue with a database where last nights backup will not restore. Having spent all morning on this and getting nowhere, I started to wonder about other things I could do to fix my current issue, then I can go back to the backup problem without having to fend off irate users.

I have isolated the individual transaction that has caused the issue, and have its id by using sys.fn_dblog

How can I edit the records in the transaction file to undelete them?
Okay, there is a reason why tools that can do this are expensive. It's by no way easy to do. However this blog post can help you.

How to create undo update statements

Since you have found the transaction, you can filter the result by using your transaction id.