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?
2
-
3You 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/…– daniloquioCommented Jul 4, 2012 at 16:56
-
2from a backup...– Derek DowneyCommented Jul 23, 2012 at 16:32
Add a comment
|
5 Answers
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
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.
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
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.
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
