I want to find deleted data from table in my SQL Server on a particular date like 17 JUNE 2012 (27/06/2012).
我想在特定日期找到我的SQL Server中的表中删除的数据,如2012年6月17日(27/06/2012)。
Is there any query which will provide this result?
有没有提供此结果的查询?
1 个解决方案
#1
0
If you have a backup from before the delete, then you will need to restore it.
如果您在删除之前有备份,则需要将其还原。
There are some recovery tools out there using transaction logs, but they aren't cheap (there are some with trials) and I'm not sure if it works on logs from before installing the tool. It also may require that the delete happened in a transaction. If it didn't then the data is probably gone.
有一些使用事务日志的恢复工具,但它们并不便宜(有一些有试用),我不确定它是否适用于安装工具之前的日志。它还可能要求删除发生在事务中。如果没有,则数据可能已经消失。
i.e. http://www.apexsql.com/sql_tools_log.aspx
It's not helpful now, but the moral here is: Use transactions when deleting anything, and do backups regularly.
它现在没有用,但这里的道德是:删除任何东西时使用事务,并定期进行备份。
#1
0
If you have a backup from before the delete, then you will need to restore it.
如果您在删除之前有备份,则需要将其还原。
There are some recovery tools out there using transaction logs, but they aren't cheap (there are some with trials) and I'm not sure if it works on logs from before installing the tool. It also may require that the delete happened in a transaction. If it didn't then the data is probably gone.
有一些使用事务日志的恢复工具,但它们并不便宜(有一些有试用),我不确定它是否适用于安装工具之前的日志。它还可能要求删除发生在事务中。如果没有,则数据可能已经消失。
i.e. http://www.apexsql.com/sql_tools_log.aspx
It's not helpful now, but the moral here is: Use transactions when deleting anything, and do backups regularly.
它现在没有用,但这里的道德是:删除任何东西时使用事务,并定期进行备份。