Cov txheej txheem:

Kuv yuav teem sijhawm backup hauv SQL li cas?
Kuv yuav teem sijhawm backup hauv SQL li cas?

Video: Kuv yuav teem sijhawm backup hauv SQL li cas?

Video: Kuv yuav teem sijhawm backup hauv SQL li cas?
Video: Cas Tsis Xaiv Koj - R-Lin Thoj New Song Original By Zaj Dub [Official MV] 2023 2024, Tej zaum
Anonim

Teem sijhawm Tsis Siv Neeg SQL Database Backup siv SSMS

  1. Nkag mus rau hauv SQL ntawv Server Management Studio (SSMS) thiab txuas mus rau lub database.
  2. Sau lub npe ntawm Txoj Kev Npaj Kho Mob uas koj yuav tsim.
  3. Tam sim no xaiv los ntawm lub qhov rais sab laug, xaiv qhov Thaub qab Database Task los teeb tsa lub thaub qab txheej txheem thiab luag lub caij mus rau sab xis qhov rais raws li qhia hauv daim duab.

Dhau li ntawd, kuv yuav teem sijhawm li cas rau SQL database thaub qab?

Yuav ua li cas teem sijhawm SQL Server database backups siv Transact-SQL

  1. Hauv lub khoos phis tawj uas tab tom khiav SQL Server Express, nyem Start, taw tes rau Txhua Qhov Kev Pabcuam, taw tes rau Accessories, taw tes rau Cov Cuab Yeej Cuab Yeej, thiab tom qab ntawd nyem Cov Haujlwm Ua Haujlwm.
  2. Ob-nias Ntxiv Teem caij ua haujlwm.
  3. Hauv Cov Txheej Txheem Ua Haujlwm Wizard, nyem Next.

Tsis tas li ntawd, kuv yuav backup SQL Server li cas? SQL Server Management Studio

  1. Txoj nyem rau ntawm lub npe database.
  2. Xaiv Tasks> Thaub qab.
  3. Xaiv "Full" raws li hom thaub qab.
  4. Xaiv "Disk" raws li qhov chaw.
  5. Nyem rau "Ntxiv" ntxiv cov ntaub ntawv thaub qab thiab ntaus "C: AdventureWorks. BAK" thiab nyem "OK"
  6. Nyem "OK" dua los tsim cov thaub qab.

Ib yam li ntawd, koj tuaj yeem nug, Kuv yuav teem sijhawm li cas rau thaub qab hauv SQL Server 2012?

  1. Mus rau MS SQL Server Management studio โ†’ SQL Server Agent โ†’ Txoj Haujlwm Tshiab.
  2. Hauv General tab sau npe thaub qab.
  3. Hauv cov kauj ruam tab: Ntaus lub npe kauj ruam. Xaiv database koj xav backup. Sau cov lus nug thaub qab.
  4. Hauv Cov Sijhawm โ†’ Tshiab, mus rau lub sijhawm tshiab thiab teem sijhawm hnub raws li qhov xav tau.

Kuv yuav teem sijhawm nug lus nug hauv SQL Server li cas?

  1. Hauv Object Explorer, txuas mus rau ib qho piv txwv ntawm SQL Server Database Cav, thiab tom qab ntawd nthuav qhov piv txwv ntawd.
  2. Nthuav SQL Server Agent, nthuav Txoj Haujlwm, right-click txoj haujlwm koj xav teem sijhawm, thiab nyem Properties.
  3. Xaiv cov nplooj ntawv Schedules, thiab tom qab ntawd nyem Tshiab.
  4. Hauv Lub Npe Lub Npe, ntaus lub npe rau lub sijhawm tshiab.

Pom zoo: