SQL Server Transaction Log Explorer/Analyzer [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 9 y开发者_如何学Goears ago.

Improve this question

What options are available for rolling back transactions after the fact in SQL Server?

I'm looking to have a plan in place before somebody deletes 10,000 of the wrong rows.

---

• RedGate SQL Log rescue (Sorry, SQL Server 2000 only. News to me)
• Apex SQL Log

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?