Uphawu:
Lapho unamathisela i-database ye-.MDF ku SQL Server, ubona umlayezo wephutha olandelayo:
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: ikhasi elidabukile (isiginesha elindelekile: 0x ########; isiginesha yangempela: 0x #########)). Kwenzeke ngesikhathi kufundwa ikhasi (#: #) ku-ID ye-database # nge-offset ### kufayela 'xxxx.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.
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. SQL Server isebenzisa izindlela ezimbili ukwenza isiqiniseko sokufana nokuhlanganiswa kwemininingwane esekhasini, okungukuthi, i-checksum noma ikhasi elidabukile. Zombili zingakhethwa.
If SQL Server ithola amakhasi adabukile amanye 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 | Iphutha5_1.mdf | Iphutha5_1_fixed.mdf |
SQL Server 2008 R2 | Iphutha5_2.mdf | Iphutha5_2_fixed.mdf |
SQL Server 2012 | Iphutha5_3.mdf | Iphutha5_3_fixed.mdf |
SQL Server 2014 | Iphutha5_4.mdf | Iphutha5_4_fixed.mdf |