Cov txheej txheem:

Yuav ua li cas rollback ua haujlwm hauv SQL Server?
Yuav ua li cas rollback ua haujlwm hauv SQL Server?

Video: Yuav ua li cas rollback ua haujlwm hauv SQL Server?

Video: Yuav ua li cas rollback ua haujlwm hauv SQL Server?
Video: Vaajtswv Lub Tebchaws/The Kingdom Of God - Nyaj Xuv Xyooj 2024, Kaum ib hlis
Anonim

Rolls rov qab ib qho kev qhia meej lossis implicit pauv mus rau qhov pib ntawm kev sib pauv, lossis mus rau qhov chaw khaws cia hauv qhov kev sib pauv. Koj siv tau ROLLBACK TRANSACTION kom tshem tawm tag nrho cov ntaub ntawv hloov kho los ntawm kev pib ua lag luam lossis mus rau qhov chaw khaws cia. Nws tseem tso cov peev txheej tuav los ntawm kev sib pauv.

Tsis tas li, kuv tuaj yeem rov qab li cas hauv SQL Server?

Siv SQL Server Management Studio

  1. Txoj nyem rau ntawm cov ntaub ntawv koj xav rov qab mus rau lub sijhawm.
  2. Xaiv Tasks/Restore/Database.
  3. Nyob rau hauv lub restore database dialog xaiv lub ncua sij hawm xaiv.

Tsis tas li ntawd, rollback ua haujlwm li cas? Nws txhais tau tias tshem tawm ib qho kev ua haujlwm. Cov txheej txheem ntawm rov qab suav nrog kev tshem tawm cov txheej txheem kev lag luam lossis kev lag luam thiab nqa cov ntaub ntawv mus rau nws lub xeev dhau los ua ntej cov kev lag luam tshwj xeeb tau ua.

Tsuas yog li ntawd, rollback ua dab tsi hauv SQL?

Hauv SQL ntawv , ROLLBACK yog ib qho lus txib uas ua rau tag nrho cov ntaub ntawv hloov pauv txij li qhov kawg BEGIN Ua Haujlwm, lossis PIB TRANSACTION raug muab pov tseg los ntawm kev sib raug zoo database tswj systems (RDBMS), kom lub xeev cov ntaub ntawv yog "dov rov qab" mus rau txoj kev nws tau ua ua ntej cov kev hloov pauv. tau ua.

Kuv yuav rov qab SQL Server li cas tom qab tshem tawm?

3 Teb. Koj ua tsis tau rov qab nyob rau hauv cov ntaub ntawv no, tab sis thaum koj siv lub Full Recovery Model, ces koj muaj peev xwm tig koj database rov qab mus rau lub sij hawm ua ntej koj muab lub rho tawm lus txib. Koj ua tsis tau ROLLBACK kev ua haujlwm tsis muaj kev lag luam.

Pom zoo: