How to recover a deleted row from SQL Server 2005 table ?

Question

Hi Gurus,

How to recover a deleted row from SQL Server 2005 table ?

Thanks,
Ahmed.

Answer 1

Rollback the transaction (if you started one).

Restore a backup (if you have one).

[edit] If you have transaction logs, you should be able to restore the backup of the database to the point roughly just before the row was deleted (assuming you know when that was).

Answer 2

Don't forget to set full recovery model for a database if you need the "restore to a point in time" option!