The problem is recovering lost data from database files (.mdf and .ldf)

Question

Recently, one of our customers deleted two million rows from a table.

The problem here is that the database is not taken from the backup. I only have a master data file (.mdf) and a log data file (.ldf) with me.

I downloaded some demo version of the Sql tool through which I can open the .mdf file. When I opened the .mdf file with the Sql tool, all the lost data is in the .mdf file, but I cannot save or export the representation of the lost data from the .mdf file from the tool until I buy it.

I followed the many steps shown on MSDN and various websites to recover, but with all the failures. Can anyone help me, what is the best way to recover deleted data and put in .ldf file. One of the sites I mentioned for data recovery is Recover Lost Data

Answer 1

What is the cost of data loss? What is the cost over time of data loss - that is, more and more, the longer the data remains lost? Compare this value with the value of the tool that you discovered, which (apparently) works, and takes into account the cost of the time it has, and suggests you find another solution. It seems likely that if they do not charge ridiculous amounts of money [can you post the product and cost?], You would be better off biting a bullet, paying them and immediately using the product, with a (implicit) guarantee of return if it does not work.

Another option is to get a transaction log reader program that can read and work with data stored in the transaction log ... but if you do not make backups, then your database (hopefully)! in simple recovery mode, and depending on how active your databases are, data can be deleted from the transaction log for a long time. However, all such programs that I have heard of also have licensing fees.

Because yes, recovering deleted data from a SQL Server database is difficult.