Answer the question
In order to leave comments, you need to log in
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
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.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question