如何回滚删除操作sql server？ [英] How to roll back delete operation sql server?

问题描述

我在我的C＃应用​​程序中有一个输入页面，我的老板可以输入销售信息。

I have an input page in my C# application whereby my boss can enter sales info.

此页面还有一个清除按钮，它清除数据库中表的内容。这个清晰的按钮方便测试，但现在在事后看来是一个错误。

This page also has a clear button, which clears the contents of the table in the database. This clear button was convenient for testing, however now in hindsight a mistake.

表中的所有记录已删除。也没有备份。

All the records in the table have been deleted. There are no backups either.

很久没有办法只使用SQL Server 2008恢复这些数据了。

Long shot, but is there any way of recovering this data using only SQL Server 2008?

推荐答案

如果你还有事务日志，还有一些工具，但这些工具会花费一些...

If you still have the transaction logs, there are some tools, but these will cost some ...

a href =http://stackoverflow.com/questions/201524/how-to-undo-a-delete-operation-in-sql-server-2005>如何撤消SQL Server 2005中的删除操作？

See How to undo a delete operation in SQL Server 2005?

和
http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log -files.html

编辑：看起来Redgate仅为SQL 2000。这留下Apex。如果你的清除功能使用TRUNCATE，你就是克里克。

Edit : Looks like Redgate is SQL 2000 only. Which leaves Apex. And if your clear function uses TRUNCATE, you are up the creek.

这篇关于如何回滚删除操作sql server？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！