Cov txheej txheem:

Kuv yuav import MDF cov ntaub ntawv li cas rau hauv SQL Server 2014?
Kuv yuav import MDF cov ntaub ntawv li cas rau hauv SQL Server 2014?

Video: Kuv yuav import MDF cov ntaub ntawv li cas rau hauv SQL Server 2014?

Video: Kuv yuav import MDF cov ntaub ntawv li cas rau hauv SQL Server 2014?
Video: Daim  Videos no yuav qhia txog drawing li ca thiab kuv yuav ua yuav ua rau hnub twg 2024, Kaum ib hlis
Anonim

Yuav Ua Li Cas Txuas Hauv Lub Ntiaj Teb Zoo Tshaj:

  1. Tua tawm SSMS.
  2. Txuas rau koj SQL Server Piv txwv.
  3. Right-click ntawm Cov ntaub ntawv hauv Object Explorer.
  4. Nyem Txuas .
  5. Hauv tus Txuas Databases qhov rai, nyem qhov Ntxiv khawm.
  6. Nrhiav rau cov directory uas muaj cov. MDF thiab.
  7. Xaiv lub.
  8. Nias OK dua txuas lub database.

Tseem yuav paub yog, kuv yuav import MDF thiab LDF cov ntaub ntawv li cas?

Cov kauj ruam yog:

  1. Ua ntej tso lub. mdf ib.
  2. Tom qab ntawd mus rau sql software, right-click "Databases" thiab nyem qhov "Attach" kev xaiv los qhib lub Attach Databases dialog box.
  3. Nyem qhov "Ntxiv" khawm kom qhib thiab nrhiav cov ntaub ntawv database los ntawm C: Program FilesMicrosoft SQL ServerMSSQL. 1MSSQLDATA nplaub tshev.
  4. Nyem qhov "OK" khawm.

Ib yam li ntawd, kuv tuaj yeem nrhiav MDF cov ntaub ntawv hauv SQL Server qhov twg? Default Location ntawm MDF Cov Ntaub Ntawv hauv SQL Server Files uas muaj ntau thiab siv los ntawm txhua qhov xwm txheej ntawm ib qho system tau nruab rau hauv daim nplaub tshev: Program Cov ntaub ntawv Microsoft SQL Server nn.

Ib sab ntawm no, kuv yuav qhib MDF cov ntaub ntawv li cas?

MDF cov ntaub ntawv hu ua Media Disc Image Cov ntaub ntawv tsim los ntawm Alcohol software, thiab cov no cov ntaub ntawv yog categorized li disk duab cov ntaub ntawv . MDF cov ntaub ntawv tuaj yeem qhib los ntawm cov ntawv thov no tab sis daim ntawv thov hu ua H + H Software Virtual CD tuaj yeem ua tau qhib MDF cov ntaub ntawv.

Dab tsi yog MDF thiab LDF cov ntaub ntawv?

MDF cov ntaub ntawv yog thawj ntaub ntawv hauv SQL server database. Cov LDF yog kev txhawb nqa ntaub ntawv . Cov tom kawg khaws cov ntaub ntawv ntsig txog kev sib pauv log. MDF muaj cov ntaub ntawv khaws cia database. LDF , ntawm qhov tod tes sau cov ntaub ntawv ntsig txog kev hloov pauv hauv lub server nrog rau tag nrho cov kev ua tau ua.

Pom zoo: