SQL Server 事务日志资源管理器/分析器 [英] SQL Server Transaction Log Explorer/Analyzer

问题描述

SQL Server 中有哪些选项可用于事后回滚事务?

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

我希望在有人删除 10,000 个错误行之前制定一个计划.

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

推荐答案

• RedGate SQL 日志救援(抱歉，仅限 SQL Server 2000.给我的消息)
• Apex SQL 日志
• RedGate SQL Log rescue (Sorry, SQL Server 2000 only. News to me)
• Apex SQL Log

我敢肯定以前还有更多.回到当我还是一名 DBA 的时候，我无法度过一个星期而不会有一些烦人的销售布偶试图鞭打我一个 GUI 或工具.

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.

我还建议您使用完全恢复进行定期备份.10k 行更新可能会有后续更改，这将使任何回滚无效.

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，我从未见过需要一个.除非它是这样设计的，否则没有人可以删除我数据库中的 10k 行:为什么我允许某人直接运行 DELETE?

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?

这篇关于SQL Server 事务日志资源管理器/分析器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！