how to recover deleted records in sql table?

[chary99]

Hi,

How to undo deleted records from a table in sql?

I've used where clause to deleted some thing like where null values are inserted but entire table rows are deleted.

Please if anyone can help in this regarding is highly appreciated.

Thanks,
Chary K

[Rabbit]

Restore from a backup. If you don't have a backup, first of all, why don't you have a backup, what are you thinking? Second, depending on your recovery model, you may be able to restore records from the logs, you will need to download or buy a log explorer. If you are running under simple recovery model or the logs have already been purged, there's not much else you can do.

[ck9663]

Or if you have a transaction set. Looks like you don't. Restoring backup is your only resort.


Good Luck!!!


~~ CK