is it possible that we can call deleted records

[asifbhura]

Hi sir,

Is there any way to call all deleted records in SQL SERVER 2000.

Waiting for reply.

Thanx in advance.

[MAK]

what do you mean by "call"?

If you do not take regular log backup, then use Lumingent logexplorer to get back deleted records.

If you do, then restore the backup all the tranlog backup in the test server and get the data back.

[asifbhura]

Hi

Thank you for showing a way such as lumingent logexplorer


I means to say to recover deleted records.
But please show me step by step

I dont know anything about lumingent logexplorer

[asifbhura]

Hi

Thank you for showing a way such as lumingent logexplorer


I means to say to recover deleted records.
But please show me step by step

I dont know anything about lumingent logexplorer

Waiting for reply

Thanx in advance

[MAK]

you have to buy the product.

Snapshot and illustration.

http://www.mssqlserver.com/products/...lorer20_p1.asp

[Rawhide]

This won't help you recover any records already deleted, but may help you with future deletions.

In a delete trigger, you can access records that were just deleted and restore them if they don't match a prescribed criteria. However, if you can quantify a set of criteria that would make you want to block a delete, you're better off using constraints on the table to prevent the delete from executing in the first place.

One way where this is helpful is to add the record to an archive or log table so that if you need to restore the record at a later date, you can retrieve it from the other table.