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 saʻo-faʻavae I / O mea sese: masaesae itulau (saini fuafuaina: 0x ### ####; saini saʻo: 0x ####). Na tupu i le taimi o le faitauga o le itulau (#: #) i le database ID # i le offset ### i le faila 'xxxx.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.

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. SQL Server faʻaaogaina ni auala se lua e mautinoa ai le tumau ma tuʻufaʻatasia o faʻamatalaga i totonu o le itulau, o lona uiga, siaki poʻo le loimata itulau. E tuu i le faitalia uma.

If SQL Server maua ai le saeia itulau mo nisi o faʻamaumauga itulau e le aoga, ona o le a lipotia lenei 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 Sese5_1.mdf Sese5_1_fixed.mdf
SQL Server 2008 R2 Sese5_2.mdf Sese5_2_fixed.mdf
SQL Server 2012 Sese5_3.mdf Sese5_3_fixed.mdf
SQL Server 2014 Sese5_4.mdf Sese5_4_fixed.mdf