Faʻailoga:

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

Ua le manuia le faʻapipiʻiina o le database mo le server 'xxx'. (Microsoft.SqlServer.Smo)

O se tuusaunoaga na tupu a o faatino le Transact-SQL faʻamatalaga poʻo le faaputuga. (Microsoft.SqlServer.ConnectionInfo)

O le ulutala mo le faila 'xxx.mdf' e le o se sao faʻamaumau faila faila. O le FILE SIZE meatotino e le saʻo. (Micosoft SQL Server, Sese: 5172)

lea 'xxx.mdf' o le igoa o le MDF faila e faʻapipiʻiina.

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. O le itulau muamua e taʻua o le faila header page, e iai le most taua faʻamatalaga e uiga i le faila atoa, pei o le faila saini, faila tele, ogatasi, ma isi

Afai o le MDF faila ulutala itulau ua faʻaleagaina pe ua faʻaleagaina, ma e le mafai ona amanaʻia e Microsoft SQL Server, lea SQL Server O le a manatu le ulutala e le aoga ma 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 Sese2_1.mdf Sese2_1_fixed.mdf
SQL Server 2008 R2 Sese2_2.mdf Sese2_2_fixed.mdf
SQL Server 2012 Sese2_3.mdf Sese2_3_fixed.mdf
SQL Server 2014 Sese2_4.mdf Sese2_4_fixed.mdf