在SQL Server 2012中检索已删除的行？ [英] Retrieving deleted rows in SQL Server 2012?

问题描述

我从SQL Server 2012数据库中删除了一些表行。我有办法以某种方式取回这些吗？如果是，请解释如何做到这一点。



谢谢

I have deleted some table rows from a SQL Server 2012 database. Is there a way for me to get these back somehow? If yes, please explain how to do that.

Thanks

推荐答案

你可以选择一些选项尝试。



如果你有备份，你可以执行备份恢复，如描述此处。但是，没有备份就不那么容易了。您可以尝试阅读SQL事务日志，但只有当您的数据库处于完全恢复模式时才能这样做。



您可以使用未记录的函数手动读取事务日志DBCC LOG或fn_dblog。请查看此主题以获取更多详细信息：

http：// stackoverflow。 com / questions / 9014531 / read-sql-server-transaction-log



第二个选项是使用某些第三方交易日志阅读器，例如 ApexSQL日志。



另一种选择是使用时间点恢复，但它会撤消您可能想要的所有其他交易保持。

There are some options you could try.

If you have backups, you can perform a backup restore like described here. However, without backups it’s not that easy. You can try reading SQL transaction log, but you can do that only if your database was in full recovery model.

You can read transaction log manually by using undocumented functions like DBCC LOG or fn_dblog. Look at this thread for more details:
http://stackoverflow.com/questions/9014531/read-sql-server-transaction-log

Second option is using some third party transaction log readers, e.g. ApexSQL Log.

Another option is to use point in time recovery, but it would undo all other transactions you might want to keep.

这篇关于在SQL Server 2012中检索已删除的行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！