patternsqlMinor
Recover accidentally deleted rows from a table
Viewed 0 times
rowsrecoverdeletedaccidentallyfromtable
Problem
My client has accidentally deleted all the records of a table from a test database. This test database is in SQL Server 2005 Express and we don't have a backup.
Is it possible to restore the deleted rows from the transaction log (.ldf) file? If yes, how?
Is it possible to restore the deleted rows from the transaction log (.ldf) file? If yes, how?
Solution
If your database is in full recovery mode you can also try third party tools such as ApexSQL Log or SQL Log Rescue.
These tools will attempt to read your transaction log and reconstruct statements.
You can also try reading transaction log manually using fn_dblog function but it’s going to be complex since this is not a well-documented function.
These tools will attempt to read your transaction log and reconstruct statements.
You can also try reading transaction log manually using fn_dblog function but it’s going to be complex since this is not a well-documented function.
Context
StackExchange Database Administrators Q#7086, answer score: 9
Revisions (0)
No revisions yet.