CODEWITHSUNDEEP
sql-server-2005data-loss
Amr Badawy
Amr Badawy

Reputation: 7693

How to recover deleted rows from SQL server table?

I accidentaly ran a DELETE command against a table with a wrong WHERE clause.

I am using SQL Server 2005.

Is there a way that could help me recover the lost data?

Upvotes: 24

Views: 132193

Answers (4)

Alok Sahoo
Alok Sahoo

Reputation: 135

It is possible using Apex Recovery Tool,i have successfully recovered my table rows which i accidentally deleted

if you download the trial version it will recover only 10th row

check here http://www.apexsql.com/sql_tools_log.aspx

Upvotes: 10

Ash Burlaczenko
Ash Burlaczenko

Reputation: 25475

I think thats impossible, sorry.

Thats why whenever running a delete or update you should always use BEGIN TRANSACTION, then COMMIT if successful or ROLLBACK if not.

Upvotes: 5

Mitch Wheat
Mitch Wheat

Reputation: 300789

You have Full data + Transaction log backups, right? You can restore to another Database from backups and then sync the deleted rows back. Lots of work though...

(Have you looked at Redgate's SQL Log Rescue? Update: it's SQL Server 2000 only)

There is Log Explorer

Upvotes: 8

spbfox
spbfox

Reputation: 949

What is gone is gone. The only protection I know of is regular backup.

Upvotes: 3

Related Questions