Uphawu:

Xa usebenzisa I-DBCC CHECKDB kunye UKULUNGISA_ALLOW_DATA_LOSS Ipharamitha yokulungisa isiseko sedatha .MDF, ngolu hlobo:

I-DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

ubona lo myalezo wemposiso ulandelayo:

Nksg 5028, iNqanaba 16, i-State 4, i-Line 4
Inkqubo ayinakho ukwenza ngokwaneleyo isiseko sedatha ukwakha kwakhona i-log.
Iziphumo ze-DBCC ze 'xxxx'.
I-CHECKDB ifumene iimpazamo zolwabiwo-0 kunye neempazamo ezi-0 zokungaguquguquki kwindawo yedatha 'xxxx'
Nksg 7909, iNqanaba 20, i-State 1, i-Line 4
Ukulungiswa kwemowudi yongxamiseko akuphumelelanga, kufuneka ubuyisele kwisipele.

apho 'i-xxxx' ligama ledatha eyonakeleyo ye-MDF elungiswa.

UMsg 5028 Impazamo ayisiyo mpazamo yolwabiwo okanye impazamo yokungqinelani.

Nakuba UMsg 7909 Impazamo enkulu enokwenzeka kwiimeko ezininzi nanini na SQL Server cinga ukuba isiseko sedatha asinakubuyiseka.

Isikrini somyalezo wemposiso:

Ingcaciso echanekileyo:

Umyalezo wemposiso (UMsg 5028) ibonakala inxulumene nefayile ye-LOG. Nangona kunjalo, le yingxelo engeyiyo. Eyona ngxaki isabangelwa lurhwaphilizo kwiziko ledatha le-MDF.

Ungayisebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisa idatha kwifayile eyonakeleyo ye-MDF kunye nokusombulula le mpazamo.

Iifayile zeSampulu:

Isampulu iifayile ze-MDF ezonakeleyo eziza kubangela UMsg 5028 imposiso:

SQL Server Inguqulelo Ifayile ye-MDF eyonakeleyo Ifayile ye-MDF elungiswe DataNumen SQL Recovery
SQL Server 2014 Impazamo3.mdf Impazamo3_fixed.mdf