Data Recovery Deleted Data In SQL Server


We have a guy at work (sorry, he’s from India) running update without specifying a where clause directly on the live database. The result is that the records of the entire table are updated, although he only needed to change one. Well, it happens to everyone, I hope that it will be rare and will bypass me.

The most annoying thing is that he did everything according to the rules – he opened a transaction, launched an update, saw that 11 thousand lines were changed instead of one, and for some reason ignored and committed the Wikipedia data. Only then did I see my joint.

Only 11 thousand rows, but in a fairly important table. Restoring a database from a backup takes too long. You need to request the last copy from the admins, get permission to copy 300 gigabytes of PCI restricted data, restore somewhere on the server and store the data. Unreal. It’s easier to update all the overwritten data with random garbage and say that Bill Gates is to blame for everything.

Then we decided to try to recover the data. We do a lot of reports and various data conversions, so the first thing we did was check all the places where there could be a copy of the data. No luck, nothing happened. 

You can restore new records that have been created since the last full copy by viewing the records in the log, which is stored on the distributor in the distribution database. Just run the command sp_browsereplcmds and it shows everything you need. Just filter the records by table by specifying the article_id parameter. 

This method is not the most ideal, because it shows SQL queries that still need to be processed, but if there is not much data to restore, then you can use it. If there is a lot of data, then it would probably be better to use a full backup. 

View More :

Data Recovery Services Is Best For Users

Disk Drill is considered the best free SD card recovery software because it can perform free Data Recovery Services up to 500 MB. It provides quick recovery from various scenarios of data loss, for example, restoring formatted SD card, recovering permanently deleted files, etc.  It uses color symbols to indicate the …

How To Data Recovery From Unallocated Hard Drive?

An external storage drive becomes unallocated when its file system becomes corrupted. This happens when a virus damages the file system, or when the hard disk has bad sectors. The unallocated drive is not visible in File Explorer, but its status can be checked in Disk Management.  Also, it is impossible to …

Data Recovery From USB Flash Drive For Free

It provides you with a simple 3-step guide to help you Data Recovery and files from USB flash drive for free. Solve the problem USB drive data not showing up and Data Recovery at the same time. Have you ever lost all the data from a USB flash drive but don’t …