CODEWITHSUNDEEP
databasesql-server-2005
Nagesh
Nagesh

Reputation: 1308

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

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

Upvotes: 1

Views: 3166

Answers (1)

Ginka
Ginka

Reputation: 570

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

Upvotes: 1

Related Questions