Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to know that is there any way that I can can recover the deleted or updated record in the sqlserver and mysql as well?

share|improve this question

migrated from Jul 5 '12 at 15:10

This question came from our site for professional and enthusiast programmers.

You should search google before asking here. Each part of your question has an existing duplicate: for SQL Server, look at this:… and for MySQL look at this one… – daniloquio Jul 4 '12 at 16:56
from a backup... – Derek Downey Jul 23 '12 at 16:32
up vote 5 down vote accepted

You always have a choice to use a recovery tools, such as ApexSQL Log for example. Not only that you can recover deleted rows, but you can also choose which rows you are going to recover.

It can recover your data from on-line, backup or detached transaction logs.

I have tried that tool and it could be the life saver.

See: How to recover SQL Server data from accidental UPDATE and DELETE operations

share|improve this answer

It depends on how you updated it and what backup/disaster recovery strategy you use.

If you are performing the DELETE within a TRANSACTION, the action can always be rolled-back until you COMMIT it.

Perhaps you're logging/auditing such operations using a trigger or similar, in which case you could find the data that was changed and do the 'opposite' to restore it.

Perhaps you're replicating the database every so often to another server - you could restore the data from there.

Perhaps you're performing backups to disk or tape in which case you might have to perform a full restore to get it back.

Failing all that - and short of forensic recovery - unless you can remember the data that was there, it's gone.

share|improve this answer

Don't really think so. Once deleted, it gets deleted permanently... This is a bit old, but haven't heard of anything else:,135990,137776#msg-137776

share|improve this answer

Once the row is deleted it is gone. You can will have to use a backup to restore the data.

The exceptions to this are if you are doing a delete inside an open Transaction, in those cases you can "Rollback" the transaction to undo any changes made inside the transaction.

share|improve this answer

Checkout this thread would be help you :

If the above url did not help you, you can try to recover this third party RecoveryFix for SQL Software. This software will restore data in working condition.


share|improve this answer

If the transaction is in a lock and did not committed, then it can be recover by using ROllback command. but if it is not in a lock then you can check your transactions using fn_dblog function

share|improve this answer
The ability to rollback changes has nothing to do with locking - only if the transaction has been committed or not. – a_horse_with_no_name Nov 3 '15 at 13:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.