网址:https://www.apexsql.com/,可免费试用14天
安装成功后,点击new,配置DB连接:
![](https://images2015.cnblogs.com/blog/675284/201509/675284-20150907103344887-1936054788.png)
选择要分析的Log文件:
![](https://images2015.cnblogs.com/blog/675284/201509/675284-20150907103931325-306563482.png)
进行过滤设置:
基本设置:时间,DML和DDL操作,知道表和系统表
高级设置:事务的状态和执行时间,过滤某个账户的执行日志,过滤某些表的某些栏位特定值的行,指定SPID,增加事务的描述
附加选项:设置结果中需要显示的列等
![](https://images2015.cnblogs.com/blog/675284/201509/675284-20150907104014106-668293714.png)
Open results in grid:
![](https://images2015.cnblogs.com/blog/675284/201509/675284-20150907104050169-163687331.png)
选中需要撤销的操作,右击选择菜单中的生成撤销脚本:
![](https://images2015.cnblogs.com/blog/675284/201509/675284-20150907104145528-1454209915.png)
确认撤销脚本无误后,执行脚本即可:
![](https://images2015.cnblogs.com/blog/675284/201509/675284-20150907104216012-687629456.png)