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 5125, iNqanaba 24, i-State 2, i-Line 2
Ifayile 'C: Iifayile zeNkqubo Microsoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf 'ibonakala ngathi incitshisiwe yinkqubo yokusebenza. Ubungakanani obulindelweyo yi-5120 KB kodwa ubungakanani obuyi-5112 KB.
Nksg 3414, iNqanaba 21, i-State 1, i-Line 2
Impazamo yenzekile ngexesha lokuchacha, ukuthintela isiseko sedatha 'Impazamo1' (39: 0) kwi-restarting. Ukuchonga iimpazamo zokubuyisela kwaye uzilungise, okanye ubuyisele kwindawo yokugcina eyaziwayo. Ukuba iimpazamo azilungiswa okanye zilindelwe, nxibelelana neNkxaso yezobuGcisa.

apho 'Impazamo1' ligama ledatha eyonakeleyo ye-MDF elungiswa.

UMsg 5125 Impazamo kukude impazamo yolwabiwo okanye impazamo yokungqinelani. Kwenzeka xa icandelo lomsila wefayile ye-MDB lisuswe, ngenxa yenkohliso yedatha.

Isikrini somyalezo wemposiso:

Ingcaciso echanekileyo:

Xa icandelo lomsila wefayile ye-MDB lisusiwe, I-CHECKDB izakuxela UMsg 5125 impazamo kwaye uzame ukuyilungisa. Ukuba i-database ayinakulungiswa, iya kuvelisa UMsg 3414 mpazamo.

Ngokwenyani isiseko sedatha sinokufunyanwa kwakhona, ukuba usebenzisa imveliso yethu DataNumen SQL Recovery ukwenza lo msebenzi.

Iifayile zeSampulu:

SQL Server Inguqulelo Ifayile ye-MDF eyonakeleyo Ifayile ye-MDF elungiswe DataNumen SQL Recovery
SQL Server 2014 Impazamo8.mdf Impazamo8Ukulungiswa.mdf

Iingxelo: