Cov txheej txheem:

Yuav ua li cas rov qab SQL database rau lwm lub database?
Yuav ua li cas rov qab SQL database rau lwm lub database?

Video: Yuav ua li cas rov qab SQL database rau lwm lub database?

Video: Yuav ua li cas rov qab SQL database rau lwm lub database?
Video: yuav tau tsim kho tus kheej lub neej thiaj yuav vam meej tau 2024, Kaum ib hlis
Anonim

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.

Ua raws li qhov no hauv kev txiav txim siab, Kuv yuav ua li cas thiaj li rov qab tau SQL database los ntawm BAK cov ntaub ntawv mus rau cov ntaub ntawv tshiab?

  1. Txoj nyem rau ntawm Database, xaiv Task -> Restore -> Database.
  2. Tom qab txhaj rau qhov kev xaiv database, lub qhov rais Restore Database qhib.
  3. Koj tuaj yeem xaiv cov ntaub ntawv rov qab los, lossis koj tuaj yeem tsim cov ntaub ntawv tshiab thaum lub sijhawm rov ua haujlwm.
  4. Qhia qhov thaub qab.
  5. Xaiv cov ntaub ntawv. BAK thiab nyem OK.
  6. Nyem OK.

Tsis tas li ntawd, koj yuav rov qab tau cov ntaub ntawv li cas? Yuav Ua Li Cas Restore Microsoft SQL Database rau Point-in-Time

  1. Qhib Microsoft SQL Server Management Studio, thiab mus rau Databases:
  2. Right-click Databases, thiab nyem Restore Database.
  3. Nyem Ntxiv nyob rau hauv Specify Backup qhov rai.
  4. Nyem OK; lub Specify Backup qhov rais qhia:
  5. Nyem OK.
  6. Nyob rau sab laug pane, nyem Options, thiab xaiv cov hauv qab no:
  7. Nyem OK los ua qhov restore.

Khaws qhov no hauv kev txiav txim siab, 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".

Yuav ua li cas kuv cia li backup SQL database?

Khiav SQL Server Management Studio Express

  1. Hauv qhov pom tsob ntoo, nthuav Cov Khoom Siv Khoom Siv Khoom Siv => Cov Cuab Yeej Tshiab Tshiab.
  2. Lub Backup Device dialog qhib.
  3. Txoj nyem rau ntawm lub cuab yeej thaub qab tshiab uas koj nyuam qhuav tsim thiab xaiv qhov kev xaiv hu ua "Backup Database".
  4. Nyob rau sab laug, xaiv Backup Options thiab teeb tsa cov hauv qab no:

Pom zoo: