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.
Well, then better get used to the non pleasent task.
The fact that:
My alternative is to go back to a local copy of this database from last month
should teach you a lesson. Take regular backups AND RESTORE THEM ON A SEPARATE MACHINE. THe later one can have normally a cheap disc subsystem as there will not be any work done on it anyway except restore and database checks.
To my knowledge there is no cheap way to rip out one transaction ouf of a log. Your boss has to decide what he values more, your time of the software.
