Cov txheej txheem:

Kuv yuav ua li cas thiaj tsim tau SQL database los ntawm BAK cov ntaub ntawv?
Kuv yuav ua li cas thiaj tsim tau SQL database los ntawm BAK cov ntaub ntawv?

Video: Kuv yuav ua li cas thiaj tsim tau SQL database los ntawm BAK cov ntaub ntawv?

Video: Kuv yuav ua li cas thiaj tsim tau SQL database los ntawm BAK cov ntaub ntawv?
Video: Автоматизация с Adobe Acrobat Pro! Пакетное преобразование файлов PDF 2024, Kaum ib hlis
Anonim

Rov qab cov ntaub ntawv los ntawm cov ntaub ntawv BAK

  1. Lub npe ntawm kev kho database tshwm hauv To database lis box. Rau tsim ib new database , sau nws lub npe rau hauv lub thawv ntawv.
  2. Xaiv 'Los ntawm ntaus ntawv'.
  3. Nias lub pob kom tso saib 'Specify Backup' Dialog.
  4. Nyem 'Ntxiv' mus xauj lub. bak ua los ntawm cov ntawv qhia zaub mov thiab nyem OK.

Ua li no, yuav ua li cas rau nruab. BAK cov ntaub ntawv hauv SQL Server?

Ntshuam BAK cov ntaub ntawv siv SQL Server Management Studio

  1. Txoj cai nyem Databases ntawm sab laug pane (Object Explorer).
  2. Nyem Restore Database…
  3. Xaiv ntaus ntawv, nyem, thiab xaiv / ntxiv koj cov ntaub ntawv.bak.
  4. Nyem OK, ces OK dua.

Ib yam li ntawd, kuv yuav ua li cas rov qab cov ntaub ntawv los ntawm ib lub database mus rau lwm qhov hauv SQL Server? Qhib SQL Server Management Studio. Right-click rau ntawm qhov database npe, ces xaiv "Tasks"> "Export cov ntaub ntawv "los ntawm cov khoom explorer. The SQL Server Ntshuam/Export wizard qhib; nyem rau ntawm "Tom ntej". Muab authentication thiab xaiv qhov chaw uas koj xav luam theej duab cov ntaub ntawv ; nyem "Tom ntej".

Ib tug kuj yuav nug, Kuv yuav ua li cas rov qab tau cov ntaub ntawv BAK?

  1. Right-click rau ntawm lub database.
  2. Mus rau cov haujlwm> rov qab> database.
  3. Kos lub xov tooj cua khawm ntawm lub cuab yeej.
  4. Nyem rau ntawm xauj rau qhov chaw.
  5. Coj mus rhaub rau ntxiv txhawm rau xaiv BAK cov ntaub ntawv.
  6. Mus rau Bak file nplaub tshev thiab xaiv nws rau kev rov ua haujlwm.
  7. Nyem OK thiab xaiv cov thaub qab koj xav rov qab.

Kuv yuav ua li cas rov qab tau cov ntaub ntawv los ntawm ib qho database mus rau lwm qhov hauv SQL Server?

Rau rov qab los a database rau qhov tshiab qhov chaw, thiab optionally rename lub database . Txuas mus rau qhov tsim nyog piv txwv ntawm cov SQL Server Database Cav, thiab tom qab ntawd hauv Object Explorer, nyem qhov server npe kom nthuav dav server tsob ntoo. Right-click Cov ntaub ntawv , thiab ces nias Restore Database . Cov Restore Database dialog box qhib.

Pom zoo: