Uphawu:
Xa usebenzisa DBCC CHECKDB kunye REPAIR_ALLOW_DATA_LOSS iparameter ukulungisa idatabase ye.MDF eyonakeleyo, 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 zikaMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf' ibonakala ngathi inqunyulwe yinkqubo yokusebenza. Ubungakanani obulindelekileyo yi-5120 KB kodwa ubukhulu bokwenene yi-5112 KB.
Nksg 3414, iNqanaba 21, i-State 1, i-Line 2
Kwenzeke impazamo ngexesha lokubuyisela, ukuthintela i-database 'Error1' (39:0) kwi-restarinto. Khangela iimpazamo zokubuyisela kwaye uzilungise, okanye ubuyisele kwi-backup efanelekileyo eyaziwayo. Ukuba iimpazamo azilungiswanga okanye zilindeleke, qhagamshelana neNkxaso yobuGcisa.
apho 'Imposiso1' ligama lesiseko sedatha esonakeleyo se-MDF elungiswayo.
UMsg 5125 Impazamo isondele kwimpazamo yolwabiwo okanye yimpazamo yokungaguquguquki. Kwenzeka xa inxalenye yomsila wefayile ye-MDB isusiwe, ngenxa yorhwaphilizo lwedatha.
Umfanekiso weskrini wemposiso:
Ingcaciso echanekileyo:
Xa inxalenye yomsila wefayile ye-MDB isusiwe, I-CHECKDB izakuxela UMsg 5125 impazamo kwaye uzame ukuyilungisa. Ukuba i-database ayinakulungiswa, ngoko iya kuvelisa UMsg 3414 mpazamo.
Ngokwenyani i-database inokufunyanwa kwakhona, ukuba usebenzisa imveliso yethu DataNumen SQL Recovery ukwenza umsebenzi.
Iifayili zesampulu:
SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
SQL Server 2014 | Impazamo8.mdf | Impazamo8_ilungisiwe.mdf |
Iingxelo: