Alamar:

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

Ba a yi nasarar dawo da bayanai ba don wannan buƙatar. (Microsoft.SqlServer.Management.Sdk.Sfc)

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

xxx.mdf ba shine fayil na asali ba na asali. (Microsoft SQL Server, Kuskure: 5171)

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 mahimmin bayani game da dukkan fayil ɗin, kamar sa hannu na fayil, girman fayil, dacewa, da dai sauransu Sauran shafukan kuma suna ƙunshe da mahimman bayanai, gami da bayanin rabon shafi da kuma ainihin bayanan.

Idan shafi na taken fayil na MDF, ko wasu mahimman shafukan gudanarwa sun lalace ko sun lalace, kuma Microsoft ba zata iya gane shi ba SQL Server, to, SQL Server zaiyi tunanin duk fayil ɗin ba ingantaccen fayil bane na tushen bayanan asali kuma yayi 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 Kuskure1_1.mdf Kuskure1_1_fixed.mdf
SQL Server 2008 R2 Kuskure1_2.mdf Kuskure1_2_fixed.mdf
SQL Server 2012 Kuskure1_3.mdf Kuskure1_3_fixed.mdf
SQL Server 2014 Kuskure1_4.mdf Kuskure1_4_fixed.mdf