Semptom:

Foydalanishda DBCC CHECKDB bilan REPAIR_ALLOW_DATA_LOSS buzilgan .MDF ma'lumotlar bazasini tuzatish parametri, shunga o'xshash:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

quyidagi xato xabarini ko'rasiz:

Msg 5028, 16-daraja, 4-holat, 4-qator
The system could not activate enough of the database to rebuild the log.
DBCC results for ‘xxxx’.
CHECKDB "xxxx" ma'lumotlar bazasida 0 ta ajratish va 0 ta xatolik aniqlandi.
Msg 7909, 20-daraja, 1-holat, 4-qator
The emergency-mode repair failed.You must restore from backup.

bu erda 'xxxx' - bu buzilayotgan MDF ma'lumotlar bazasining nomi.

MSG 5028 error is neither an allocation error or a consistency error.

paytda MSG 7909 har doim ko'p holatlarda yuzaga kelishi mumkin bo'lgan jiddiy xato SQL Server ma'lumotlar bazasini tiklashdan tashqari deb o'ylayman.

Xato haqidagi xabarning skrinshoti:

Aniq tushuntirish:

The error message(MSG 5028) seems to be related to the LOG file. However, this is a misreport. The actual problem is still caused by the corruption of the MDF database.

Siz bizning mahsulotimizdan foydalanishingiz mumkin DataNumen SQL Recovery buzilgan MDF faylidan ma'lumotlarni qayta tiklash va ushbu xatoni hal qilish.

Namuna fayllari:

Bunga sabab bo'ladigan buzilgan MDF fayllarining namunasi MSG 5028 xato:

SQL Server versiya Buzuq MDF fayli MDF fayli tomonidan o'rnatildi DataNumen SQL Recovery
SQL Server 2014 Xato3.mdf Xato3_fixed.mdf