检索表中已删除的行

编程入门行业动态更新时间:2024-10-26 08:32:45

本文介绍了检索表中已删除的行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述

我正在使用SQLServer 2005而且我错误地删除了一个表中的一些值，现在我想要恢复已删除的数据。 /> 有什么办法吗？我没有任何备份。使用< code> DELETE< / code>删除记录声明。

解决方案

这里 [ ^ ]是一种方法。祝你好运，但并不总是有效。您应该始终备份数据库，以尽量减少损失来自这样的情况。

SQL Server提供时间点恢复 www.mssqltips/tip.asp?tip=1229 [ ^ ] 但是，如果你没有备份和没有交易日志，那你就不走运了！

你好b $ b 试试看这可以帮到你 http：// searchsqlserver.techtarget/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 www.mssqltips/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 searchsqlserver.techtarget/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: