Does anybody have suggestions for a 3rd party SQL log analyzer that will allow a DBA to roll back a transaction from the transaction log? Any experiences to be shared?
This isn't a: "Help! I blew up my database." question. I'm looking to have a plan in place before somebody deletes 10,000 of the wrong rows.
I know that Apex makes a product. Are there competing packages out there?
Experiences, suggestions?
I'm sure there used to be more. Back when I was a prod DBA I couldn't get through a week without some irritating Sales muppet trying to flog me a GUI or tool.
I would also suggest you take regular backups with FULL recovery. A 10k rows update may have subsequent changes that will invalidate any rollback.
FWIW, I've never seen the need for one. No-one can delete 10k rows in my DB anyway unless it's designed that way: why would I allow someone to run DELETE directly?