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 bayanan da ke cikin fayil ɗin MDF azaman shafuka, tare da kowane shafi yana da girman 8KB. Shafin farko, wanda ake kira shafin taken fayil, ya ƙunshi most mahimman bayanai game da dukan fayil ɗin, gami da sa hannun fayil ɗin, girman, dacewa, da sauran muhimman bayanai.

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