回滚删除查询 [英] Roll back a delete query

问题描述

我执行了删除查询，但没有包含事务.现在我要撤消删除该怎么办?
请帮帮我！

I executed a delete query without including in a transaction. now i want to undo the deletion what shoul i do?
please help me!!

推荐答案

Wanlambok写道:

Wanlambok wrote:

我执行了删除查询而不包含在交易中.

I executed a delete query without including in a transaction.

我怀疑它是否可以再获取了！如果没有事务，它就完成了...如果有SQL日志文件或历史记录表，则可能会得到一些与之相关的信息，但不是整个记录！

I doubt it can be retrieved anymore! Without transaction it is done and gone... If SQL log files or history table in place, you might get some info related to it but not the whole record!

如果您进行常规备份在数据库中，您可以使用此备份恢复数据.

If you take regular backups of the database, you can get your data back using this backup.

有第三方工具可以执行此操作.该工具应该能够进入事务日志并查看日志条目，以便可以看到发生了什么. Red-Gate有一个: SQL日志救援 [ MSDN -undo delete语句. . [

There are third-party tools to do this. The tool should be able to go into the transaction logs and view the log entries so you can see what happened. There is one by Red-Gate: SQL Log Rescue[^].
Also check this post: MSDN -undo delete statement...is it possible?[^]

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