Is there any provision for recovering data after executing a DELETE?
Q: I have a table name “Test”.There are few records in the table. Now i execute a query “Delete from Test ” so this query will delete all the data from the table “Test” . Now my question is that Is there is any provision to recover that data just after executing delete query . I mean to say i executed delete query mistakely so i want to recover that data.
Iain Kick says: Well, that’s sort of a tough one. There is no native provision for doing this type of data recovery unless you put the DELETE statement in a transaction (always good practice) then you can issue a rollback if required. Being able to rollback transactions is a crucial task for administering any database, so taking the precaution to include these DELETE’s in a transaction is something to keep front of mind.
Technorati Tags:
data recovery, DELETE, rollback transactions
