Uphawu:
Lapho unamathisela i-database ye-.MDF ku SQL Server, ubona umlayezo wephutha olandelayo:
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0x2abc3894; uqobo: 0x2ebe208e). Kwenzeke ngesikhathi kufundwa ikhasi (1: 1) ku-ID 12 egciniwe nge-offset 0x00000000002000 kufayela elithi 'xxx.mdf'. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi SQL Server, Iphutha: 824)
lapho 'xxx.mdf' igama lefayela le-MDF litholakala.
Kwesinye isikhathi i-database ye-.MDF ingaxhunywa ngempumelelo. Kodwa-ke, lapho uzama ukwenza isitatimende se-SQL, njenge
KHETHA * KUSUKA KU- [TestDB]. [Dbo]. [Test_table_1]
uzothola umyalezo wephutha ongenhla.
Isithombe-skrini somlayezo wephutha:
Incazelo eqondile:
Imininingwane esefayilini le-MDF igcinwa njengamakhasi, ikhasi ngalinye lingu-8KB. Ikhasi ngalinye linenkambu ye-checksum yokuzikhethela.
If SQL Server ithola amanani we-checksum kwamanye amakhasi wedatha angavumelekile, khona-ke izobika leli phutha.
Ungasebenzisa umkhiqizo wethu DataNumen SQL Recovery ukubuyisa idatha kusuka kufayela le-MDF elonakele bese uxazulula leli phutha.
Amafayela Esampula:
Sampula amafayela we-MDF akhohlakele azodala iphutha:
SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
SQL Server 2005 | Iphutha4_1.mdf | Iphutha4_1_fixed.mdf |
SQL Server 2008 R2 | Iphutha4_2.mdf | Iphutha4_2_fixed.mdf |
SQL Server 2012 | Iphutha4_3.mdf | Iphutha4_3_fixed.mdf |
SQL Server 2014 | Iphutha4_4.mdf | Iphutha4_4_fixed.mdf |