检索表中已删除的行 [英] Retrieve Back Deleted rows in table

问题描述

我正在使用SQLServer 2005而且我错误地删除了一个表中的一些值，现在我想要恢复已删除的数据。 />


有什么办法吗？我没有任何备份。



使用< code> DELETE< / code>删除记录声明。

解决方案

这里 [ ^ ]是一种方法。



祝你好运，但并不总是有效。



您应该始终备份数据库，以尽量减少损失来自这样的情况。

SQL Server提供时间点恢复



http://www.mssqltips.com/tip.asp?tip=1229 [ ^ ]



但是，如果你没有备份和没有交易日志，那你就不走运了！

你好b $ b

试试看这可以帮到你



http：// searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1219179,00.html



恢复工具

另一种选择是使用恢复工具，允许您读取SQL Server事务日志，然后撤消事务并恢复已删除的表 - 在某些情况下甚至是截断的表。由于所有事务都记录在事务日志中，使用这些工具可以读取并创建T-SQL语句来撤消语句甚至撤消truncate table语句。

其中一些恢复工具是：

• Lumigent Technologies的Log Explorer
• ApexSQL LLC的ApexSQL日志
• Red-Gate Software Ltd .SQL日志救援

Hi,

I am using SQLServer 2005 and by mistake I have deleted some of the values in one table now I want to recover the deleted data.

Is there any way? I don't have any backups.

Records has been deleted using <code>DELETE</code> statement.

解决方案

Here[^] is one method.

Good luck though, it doesn't always work.

You should always take backups of databases to minimize any losses from situations like this.

SQL Server offers point in time recovery

http://www.mssqltips.com/tip.asp?tip=1229[^]

However, if you have no backups and no transaction logs, then you're out of luck!

Hi
Try this may helps you

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1219179,00.html

Recovery tools
Another option is to use recovery tools that allow you to read the SQL Server transaction log and then undo transactions and recover deleted tables -- even the truncated tables in some cases. Since all transactions are recorded in the transaction log, with these tools you can read through and create T-SQL statements to undo the statement or even undo a truncate table statement.
Some of these recovery tools are:

• Lumigent Technologies' Log Explorer
• ApexSQL LLC's ApexSQL Log
• Red-Gate Software Ltd.'s SQL Log Rescue

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