What is the recovery problem in Microsoft SQL Server?

V

Veronica Kop2018-07-15 21:42:59

SQL Server

Veronica Kop, 2018-07-15 21:42:59

When running the DBCC CHECKDB program, ms sql database corruption was detected. None of the recovery methods help. An attempt to restore from a backup was useless, the data was also corrupted. What to do now?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

K

Konstantin Tsvetkov, 2018-07-15
@tsklab

What to do now?

Look for uncorrupted backups.

M

Maxim Yaroshevich, 2018-07-16
@YMax

The database is not 1C by any chance? If so, then through unloading to .dt and subsequent loading everything is treated without problems, I did this several times with the working base.

L

Lily Timoshenko, 2018-07-20
@lilytimoshenko

If the corruption occurred before the database was backed up, then of course the backup will contain the corrupted version of the database, and recovery will be more difficult. Try reading tips on recovering from damage, maybe you will find https://technet.microsoft.com/en-us/library/ee9146... there is also a utility for repairing the ms sql database https://www.repairtoolbox. com/ru/sqlserverrepair.html but this is when nothing helps at all, maybe even just for your case.