如何恢复已删除的记录。 [英] How to recover deleted records.

问题描述

大家好..

我不小心对一个带有错误WHERE子句的表运行DELETE命令。

我的数据库没有备份。

所以我怎么能恢复丢失的桌子数据。

谢谢。

Hello everyone..
I accidentaly run a DELETE command against a table with a wrong WHERE clause.
My database had no backup.
so how can i recover lost data of the table.
thank you.

推荐答案

参见在其中 [ ^ ]。它看起来很熟悉吗？ ： - ）

See here[^]. Does it look familiar? :-)

这个帖子差不多4年了，但我留下我的评论给那些会发现这个麻烦的人。有一种方法可以使用事务日志和LSN（日志序列号）来恢复丢失的数据。知道失败时的日期和时间也会很好。您需要执行许多步骤。请告诉您详细信息 http://sqlbak.com/blog/recover-deleted -data-in-sql-server / 希望是有用的

This thread is almost 4 years old, but i leave my comment for those who will find this thread with such a trouble. There is a way to recover missing data by using Transaction Logs and LSNs (Log Sequence Numbers). It would be good also to know date and time when happened a lose. There are many steps which you need to do. Just give you a reference where are details http://sqlbak.com/blog/recover-deleted-data-in-sql-server/Hope would be useful

这篇关于如何恢复已删除的记录。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！