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 824, iNqanaba 24, i-State 2, i-Line 2
SQL Server kuchongwe impazamo ye-I/O esekwe ngokwengqiqo: i-pageid engachanekanga (ekulindeleke 1:143; eyona 0:9). Yenzekile ngexesha lokufunda kwephepha (1:143) kwi-database ID 39 kwi-offset 0x0000000011e000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 3313, iNqanaba 21, i-State 1, i-Line 2
Ngexesha lokwenziwa kwakhona komsebenzi ongenisiweyo kwisiseko sedatha 'Impazamo1', kwenzeke impazamo kwirekhodi ye-ID yerekhodi (135:752:2). Ngokuqhelekileyo, ukungaphumeleli okukodwa kufakwe ngaphambili njengempazamo kwinkonzo ye-Windows Event Log. Buyisela i-database kwi-backup epheleleyo, okanye ulungise i-database.
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.
Nksg 824, iNqanaba 24, i-State 2, i-Line 2
SQL Server kuchongwe impazamo ye-I/O esekwe ngokwengqiqo: i-pageid engachanekanga (ekulindeleke 1:160; eyona 0:41). Yenzekile ngexesha lokufunda kwephepha (1:160) kwi-database ID 39 kwi-offset 0x00000000140000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 4
SQL Server kuchongwe impazamo ye-I/O esekwe ngokwengqiqo: i-pageid engachanekanga (ekulindeleke 1:160; eyona 0:41). Yenzekile ngexesha lokufunda kwephepha (1:160) kwi-database ID 39 kwi-offset 0x00000000140000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
apho 'Imposiso1' ligama lesiseko sedatha esonakeleyo se-MDF elungiswayo.
UMsg 3313 ibonisa umsebenzi welog ongenakwenziwa.
Umfanekiso weskrini wemposiso:
Ingcaciso echanekileyo:
Xa i-CHECKDB ingakwazi ukwenza umsebenzi ofakiweyo, iya kuchaza umyalezo wemposiso UMsg 3313 kwaye uzame ukulungisa iimpazamo. Ukuba ayikwazi ukulungisa impazamo, ke ukubuyiswa akuphumeleli kwaye kuya kukhokelela kwiimpazamo ezininzi, ezifana Msg 3414 kunye noMsg 824.
Ungasebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisela idatha kwifayile ye-MDF eyonakele kwaye uyisombulule le mpazamo.
Iifayili zesampulu:
Isampulu yeefayile zeMDF ezonakeleyo eziya kubangela i UMsg 3313 imposiso:
| SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2014 | Imposiso9.mdf | Imposiso9_ilungisiwe.mdf |