Alamar:

Lokacin kokarin haɗawa da .MDF bayanai a ciki SQL Server, kun ga wadannan kuskuren sako:

Haɗa bayanan bayanan bai yi nasarar Sabar 'xxx' ba (Microsoft.SqlServer.Smo)

Banda ya faru yayin aiwatar da bayanin Transact-SQL ko tsari. (Microsoft.SqlServer.ConnectionInfo)

Kan taken fayil 'xxx.mdf' ba ingantaccen taken fayil bane. Kadarorin FILE SIZE ba daidai bane. (Micosoft SQL Server, Kuskure: 5172)

inda 'xxx.mdf' shine sunan fayil ɗin MDF da za'a haɗa.

Hoton kuskuren hoto:

Daidaitaccen Bayani:

Ana adana bayanai a cikin fayil na MDF azaman shafuka, kowane shafi yana 8KB. Shafin farko ana kiransa shafin taken fayil, wanda ya ƙunshi most muhimmin bayani game da dukkan fayil ɗin, kamar sa hannu na fayil, girman fayil, jituwa, da dai sauransu.

Idan shafi na taken fayil na MDF ya lalace ko ya lalace, kuma Microsoft ba za ta iya gane shi ba SQL Server, to, SQL Server za suyi tunanin cewa rubutun baya aiki kuma sun bayar da rahoton wannan kuskuren.

Zaka iya amfani da samfurinmu DataNumen SQL Recovery don dawo da bayanan daga fayil ɗin MDF mai lalata kuma warware wannan kuskuren.

Samfurin fayiloli:

Samfurin gurɓatattun fayilolin MDF waɗanda zasu haifar da kuskure:

SQL Server version Gurbataccen MDF fayil Fayil MDF ta gyara DataNumen SQL Recovery
SQL Server 2005 Kuskure2_1.mdf Kuskure2_1_fixed.mdf
SQL Server 2008 R2 Kuskure2_2.mdf Kuskure2_2_fixed.mdf
SQL Server 2012 Kuskure2_3.mdf Kuskure2_3_fixed.mdf
SQL Server 2014 Kuskure2_4.mdf Kuskure2_4_fixed.mdf