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:
Iziphumo zeDBCC ze'xxxx'.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-0 ezihambelanayo kwiziko ledatha 'xxxx'.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchonge impazamo ye-I/O esekwe ngokwengqiqo: i-checksum engachanekanga (elindelweyo: 0xea8a9a2f; eyona: 0x37adbff8). Yenzekile ngexesha lokufunda iphepha (1:28) kwiziko ledatha ID 39 kwi-offset 0x00000000038000 kwifayile 'xxxx.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 'xxxx.mdf' ligama lefayile yeMDF eyonakeleyo elungiswayo. Nangona i-CHECKDB ithi
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-0 ezihambelanayo kwiziko ledatha 'xxxx'.
Oku kuseyimpazamo yokuhambelana (UMsg 824) kuvimba weenkcukacha.
Umfanekiso weskrini wemposiso:
Ukuba urhwaphilizo lukhulu, ngoko kuyakubakho imiyalezo yemposiso eqhubekayo (UMsg 824), njengoko kungezantsi:
Nksg 824, iNqanaba 24, i-State 6, i-Line 2 SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelweyo: 0x3d17dfef; eyona: 0xd81748ef). Yenzekile ngexesha lokufunda iphepha (1:0) kwiziko ledatha ID 39 kwi-offset 0000000000000000 kwifayile 'xxxx.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 6, i-Line 4 SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelweyo: 0x3d17dfef; eyona: 0xd81748ef). Yenzekile ngexesha lokufunda iphepha (1:0) kwiziko ledatha ID 39 kwi-offset 0000000000000000 kwifayile 'xxxx.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 'xxxx.mdf' ligama lefayile yeMDF eyonakeleyo elungiswayo.
Umfanekiso weskrini wemposiso:
Ukuba urhwaphilizo lukhulu kakhulu, uyabona UMsg 7909 ndelayo UMsg 824:
Iziphumo zeDBCC ze'xxxx'.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-0 ezihambelanayo kwiziko ledatha 'xxxx'.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe ngokwengqiqo: i-checksum engachanekanga (elindelweyo: 0xcfcd2118; eyona: 0x6fc599d6). Yenzekile ngexesha lokufunda iphepha (1:1) kwiziko ledatha ID 39 kwi-offset 0x00000000002000 kwifayile 'xxxx.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 7909, iNqanaba 20, i-State 1, i-Line 8
Ulungiso lwemo engxamisekileyo aluphumelelanga.Kufuneka ubuyisele kwi-backup.
apho 'xxxx' ligama lesiseko sedatha kwaye 'xxxx.mdf' ligama lefayile yedata ekhoyo.
Phawula UMsg 7909 yimpazamo enkulu enokuthi yenzeke kwiimeko ezininzi nanini na SQL Server cinga ukuba i-database ingaphaya kokubuyisela.
Umfanekiso weskrini wemposiso:
Ingcaciso echanekileyo:
Idatha kwifayile ye-MDF igcinwe njenge-8KB Maphepha. Iphepha ngalinye linendawo ekhethiweyo yokutshekisha.
Ukuba umyalelo we-DBCC CHECKDB ufumana amaxabiso etshekhi kwiphepha elingasentla, iphepha le-PFS kunye namanye amaphepha edatha awasebenzi kwaye awakwazi ukulungisa ingxaki, ngoko izakuxela le mpazamo(UMsg 824). Ukuba ukonakala kubi kakhulu, kusenokubakho iimpazamo eziqhubekayo(UMsg 824) okanye ilandelwe yenye impazamo (UMsg 7909).
Ungasebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisela idatha kwifayile ye-MDF eyonakele kwaye uyisombulule le mpazamo.
Iifayili zesampulu:
Isampulu yeefayile zeMDF ezonakeleyo eziza kubangela impazamo (Impazamo enye kaMsg 824):
| SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2014 | Imposiso1_3.mdf | Imposiso1_3_fixed.mdf |
Isampulu yeefayile zeMDF ezonakeleyo eziza kubangela impazamo (Iimpazamo eziqhubekayo zikaMsg 824):
| SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2014 | Imposiso1_1.mdf | Imposiso1_1_ilungisiwe.mdf |
Isampulu yeefayile zeMDF ezonakeleyo eziza kubangela impazamo (Imposiso ye-Msg 824 ilandelwa yimpazamo kaMsg 7909):
| SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2014 | Imposiso1_2.mdf | Imposiso1_2_fixed.mdf |