Faʻailoga:

A faʻapipiʻi se .MDF database i totonu SQL Server, oe vaʻai ile feʻau sese lea:

SQL Server na maitauina se sese talafeagai-faʻavae I / O mea sese: sese siaki (faʻamoemoeina: 0x2abc3894; moni: 0x2ebe208e). Na tupu i le taimi o le faitauga o le itulau (1: 1) i le database ID 12 i le offset 0x00000000002000 i le faila 'xxx.mdf'. Faʻaopoopoga feau i le SQL Server mea sese mea na tupu poʻo le polokalama mea tupu log mafai ona maua ai nisi auiliiliga Ose mea leaga tele lea e lamatia ai le faʻamaumauga o faʻamaumauga ma e ao ona toe faʻasaʻo. Faʻamaeʻa le atoa faʻamaumauga tuʻufaʻatasiga siaki (DBCC CHECKDB). O lenei mea sese e mafai ona mafua mai i le tele o mea taua; mo nisi faʻamatalaga, vaʻai SQL Server Tusi i luga ole laiga. (Microsoft SQL Server, Sese: 824)

o fea le 'xxx.mdf' o le igoa o le faila MDF ua ulufale atu i ai.

O nisi taimi o oe le .MDF database ono faʻapipiʻi manuia. Ae peitaʻi, a e taumafai e faʻatino se SQL faʻamatalaga, pei o

FILIFILIA * MAI [TestDB]. [Dbo]. [Test_table_1]

oe o le a maua foi le luga sese feʻau.

Puʻe ata o le mea sese tala:

Faʻamatalaga Tonu:

O faʻamatalaga i le faila MDF e teuina pei o itulau, o itulau taʻitasi e 8KB. Taʻitasi itulau ua i ai a tuu i le faitalia filifiliga fanua.

If SQL Server maua ai le siaki siaki i nisi o faʻamatalaga itulau e le aoga, ona o le a lipotia lenei mea sese.

E mafai ona e faʻaogaina la matou oloa DataNumen SQL Recovery ia toe maua mai faʻamatalaga mai le faila leaga MDF ma fofo lenei sese.

Faila faataʻitaʻi:

Faʻataʻitaʻiga faʻaletonu faila MDF o le a mafua ai le mea sese:

SQL Server faʻamatalaga Faila palapala MDF MDF faila faʻamau e DataNumen SQL Recovery
SQL Server 2005 Sese4_1.mdf Sese4_1_fixed.mdf
SQL Server 2008 R2 Sese4_2.mdf Sese4_2_fixed.mdf
SQL Server 2012 Sese4_3.mdf Sese4_3_fixed.mdf
SQL Server 2014 Sese4_4.mdf Sese4_4_fixed.mdf