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 mafai ona toe aumaia faʻamatalaga mo lenei talosaga. (Microsoft.SqlServer.Management.Sdk.Sfc)

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

xxx.mdf e le o se faila faila muamua. (Microsoft SQL Server, Sese: 5171)

o fea le 'xxx.mdf o le igoa o le faila MDF 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, e pei o le faila saini, faila tele, ogatasi, ma isi O loʻo totoe itulau o loʻo iai foʻi faʻamatalaga taua, e aofia ai le itulau faʻasoaga faʻamatalaga faʻapea foi ma le moni faʻamaumauga.

Afai o le MDF faila ulutala itulau, poʻo isi taua taua pulega itulau ua faʻaleagaina pe faʻaletonu, ma le mafai ona amanaʻia e Microsoft SQL Server, lea SQL Server O le a manatu le atoa faila e le o se aoga muamua faila faʻamaumauga ma lipoti 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 Sese1_1.mdf Sese1_1_fixed.mdf
SQL Server 2008 R2 Sese1_2.mdf Sese1_2_fixed.mdf
SQL Server 2012 Sese1_3.mdf Sese1_3_fixed.mdf
SQL Server 2014 Sese1_4.mdf Sese1_4_fixed.mdf