Cov txheej txheem:

Dab tsi yog qhov sib txawv backup SQL Server?
Dab tsi yog qhov sib txawv backup SQL Server?

Video: Dab tsi yog qhov sib txawv backup SQL Server?

Video: Dab tsi yog qhov sib txawv backup SQL Server?
Video: Yog hmoov dab tsi - Gao Nou Kue ft. Mang Vang (Official Music Video) New song 2020 2024, Kaum ib hlis
Anonim

Differential thaub qab ntawm Microsoft SQL Server txhais tau hais tias thaub qab tsuas yog cov ntaub ntawv uas tau hloov txij li thaum kawg tag nrho thaub qab . Hom no thaub qab xav kom koj ua haujlwm nrog cov ntaub ntawv tsawg dua li cov ntaub ntawv tag nrho thaub qab , hos kuj shortening lub sij hawm yuav tsum tau ua kom tiav a thaub qab.

Hais txog qhov no, qhov sib txawv backup ua haujlwm li cas hauv SQL Server?

A Differential backup yog raws li cov ntaub ntawv tam sim no, yav dhau los tag nrho thaub qab . A sib txawv backup captures xwb cov ntaub ntawv uas tau hloov txij li thaum tag nrho thaub qab . Qhov puv thaub qab pe koj a Differential backup yog raws yog hu ua lub hauv paus ntawm lub sib txawv.

Ib sab saum toj no, qhov txawv ntawm tag nrho thiab qhov sib txawv backup yog dab tsi? Cov txawv yog a Differential thaub qab ib txwm muaj tag nrho cov ntaub ntawv tshiab lossis hloov kho txij li lub thaub qab tag nrho . A Differential thaub qab txij hnub Wednesday yuav muaj kev hloov pauv txij hnub Tuesday thiab Wednesday, thiab a Differential thaub qab txij hnub Friday yuav muaj kev hloov pauv txij hnub Tuesday, Wednesday, Thursday, thiab Friday.

Tom qab ntawd, ib tug kuj yuav nug, dab tsi yog qhov txawv database backup?

A sib txawv backup yog hom ntaub ntawv thaub qab txoj kev uas luam tag nrho cov ntaub ntawv uas tau hloov txij li thaum kawg tag nrho thaub qab tau ua.

Kuv yuav ua li cas los tsim ib tug txawv backup?

Tsim SQL Server Differential Backup rau ib daim ntawv disk

  1. Txoj nyem rau ntawm lub npe database.
  2. Xaiv Tasks> Thaub qab.
  3. Xaiv "Differential" 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. DIF" thiab nyem "OK"
  6. Nyem "OK" dua los tsim cov thaub qab.

Pom zoo: