Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Jul 5 '12 at 15:10

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

3  
You should search google before asking here. Each part of your question has an existing duplicate: for SQL Server, look at this: stackoverflow.com/questions/3540729/… and for MySQL look at this one stackoverflow.com/questions/6924823/… –  daniloquio Jul 4 '12 at 16:56
2  
from a backup... –  Derek Downey Jul 23 '12 at 16:32

6 Answers 6

up vote 3 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

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

Don't really think so. Once deleted, it gets deleted permanently... This is a bit old, but haven't heard of anything else: http://forums.mysql.com/read.php?21,135990,137776#msg-137776

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

Checkout this thread would be help you :

http://technet.microsoft.com/en-us/library/dd207003.aspx

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.

Thanks

share|improve this answer

There is a way to get back your records from a backup without using any tools. I've found an article which details, step by step, with an example, what you have to do in order to get back those records.

You can find the article here: http://sqlbak.com/blog/recover-deleted-data-in-sql-server/

I have used these steps a few times and it worked everytime for me, so I can vouch for it.

share|improve this answer

Your Answer

 
discard

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.