How to retrive the singe deleted record in table

Question

Hi,

I  delete a  single record in a table. i want to retrieve that single record. what can i do?

Answer 1

There is no direct way. What you can do is restore the database to a time point before deletion if your db is full recovery mode and have necessary backups. or restore it from any recent database backups where you have a chance of loosing some data.

Regards
Satheesh