How to recover deleted rows from SQL server table

Question

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

[sql-server-2005] How to recover deleted rows from SQL server table?

Examples related to sql-server-2005

Examples related to data-loss