开发者

Recovering deleted transaction data from SQL Server database and log in Simple Recovery Model

开发者 https://www.devze.com 2023-02-14 22:55 出处:网络
We have a SQL Server 2005 database whose reovery model is Simple. One of 开发者_运维问答the users has deleted few important records from few tables accidentally. It is not possible to recover the data

We have a SQL Server 2005 database whose reovery model is Simple. One of 开发者_运维问答the users has deleted few important records from few tables accidentally. It is not possible to recover the data from SQL Server transaction logs when the recovery modle is Simple. I have heard that there are recovery tools like EnCase, Evidence Eliminator etc., using which one can recover the deleted files from the hard disk. Can it be possible to restore the state of disk files at any point in time? Please provide your inputs.

Thanks in Advance


As shown in this link http://msdn.microsoft.com/en-us/library/ms189275.aspx with simple recovery model there are no log backups, you should restore from a previous backup

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号