Cov txheej txheem:

Kuv yuav rov qab tau cov ntaub ntawv li cas rau ib qho chaw sib txawv?
Kuv yuav rov qab tau cov ntaub ntawv li cas rau ib qho chaw sib txawv?

Video: Kuv yuav rov qab tau cov ntaub ntawv li cas rau ib qho chaw sib txawv?

Video: Kuv yuav rov qab tau cov ntaub ntawv li cas rau ib qho chaw sib txawv?
Video: FBI / KUB - Ntawv Caw (Official Full Song + Lyrics) 2024, Kaum ib hlis
Anonim

Txhawm rau rov kho cov ntaub ntawv mus rau qhov chaw tshiab, thiab xaiv hloov lub npe database

  1. Txuas mus rau qhov tsim nyog piv txwv ntawm SQL Server Database Cav, thiab tom qab ntawd hauv Object Explorer, nyem qhov server npe kom nthuav dav server tsob ntoo.
  2. Right-click Cov ntaub ntawv , thiab ces nias Restore Database .

Tom qab ntawd, ib tug kuj yuav nug, yuav ua li cas koj restore ib. BAK cov ntaub ntawv rau ib tug tshiab database?

  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.

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".

Ntxiv mus, kuv yuav ua li cas los tsim ib tug backup database?

Qhib lub database uas koj xav tsim ib daim ntawv luam theej thiab ua cov hauv qab no:

  1. Nyem Cov Ntaub Ntawv, thiab tom qab ntawd nyem Txuag Raws li.
  2. Hauv Cov Ntaub Ntawv Hom, nyem Txuag Database As.
  3. Hauv Advanced, nyem Back Up Database, thiab tom qab ntawd nyem Txuag Raws li.
  4. Nyob rau hauv Txuag Raws li dialog box, nyob rau hauv cov ntaub ntawv lub npe lub thawv, tshuaj xyuas lub npe rau koj database backup.

Kuv yuav backup SQL database rau lwm tus neeg rau zaub mov li cas?

  1. Qhib SQL Server Management Studio Express thiab txuas mus rau SQL neeg rau zaub mov.
  2. Nthuav Databases.
  3. Txoj cai-nias rau ntawm cov ntaub ntawv koj xav thaub qab, ces xaiv Tasks> Backup.
  4. Nyob rau lub qhov rais Back Up Database, xyuas kom cov Database teb muaj lub npe ntawm cov ntaub ntawv koj xav rov qab.
  5. Xaiv hom thaub qab.

Pom zoo: