O
O
Oleg Tarakanov2015-07-07 14:23:54
Backup
Oleg Tarakanov, 2015-07-07 14:23:54

How to read data from corrupted backup (MS SQL)?

Hello!
There is a backup of the database, which was deleted and corrupted - the first cluster was overwritten by the application logs.
The task consists in picking out several tables from a backup.
The DBMS does not recognize the file as a medium. I will be glad to any advice.
Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg Tarakanov, 2015-07-09
@druoleg

The task is practically solved.
I made a new backup of the database, opened both backups in the HEX editor in the comparison mode.
Replaced bad sectors with data from a new backup.
Now the studio still does not want to see the contents of the backup through the GUI, but if we restore the database from the console, we get an error:

5 percent processed.
10 percent processed.
15 percent processed.
20 percent processed.
25 percent processed.
30 percent processed.
35 percent processed.
40 percent processed.
45 percent processed.
50 percent processed.
55% processed.
60 percent processed.
65% processed.
70 percent processed.
75% processed.
80 percent processed.
85 percent processed.
90 percent processed.
95 percent processed.
100 percent processed.
Msg 3203, Level 16, State 1, Line 2
Read on "D:\DB\ns_db\2015-06-03.bak" failed: 38
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

Previously tried "openers" ApexSQL Recover 2014 and SysTools Backup Recovery - could not open.
After a manual fix, ApexSQL still does not understand the backup, and SysTools was able to open it, but asks to eat. The task is not worth the requested money, so I continue to ditch the backup in the direction of free reading.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question