Cov txheej txheem:

SQL Server backup yog dab tsi?
SQL Server backup yog dab tsi?

Video: SQL Server backup yog dab tsi?

Video: SQL Server backup yog dab tsi?
Video: #21 Cara Export (Backup) dan Import (Execute) Database SQL dengan SQLyog | SISTEM BASIS DATA 2024, Hlis ntuj nqeg
Anonim

thaub qab [npe]

Ib daim qauv ntawm SQL Server cov ntaub ntawv uas tuaj yeem siv los kho thiab rov qab cov ntaub ntawv tom qab ua tsis tiav. A thaub qab ntawm SQL Server cov ntaub ntawv yog tsim nyob rau theem ntawm ib tug database los yog ib los yog ntau tshaj ntawm nws cov ntaub ntawv los yog filegroups. Cov lus-theem backups tsis tuaj yeem tsim.

Raws li txoj cai, SQL Server database backup yog dab tsi?

Tus txheej txheem ntawm kev tsim ib thaub qab [noun] los ntawm luam cov ntaub ntawv los ntawm a SQL Server database , los yog cov ntaub ntawv teev tseg los ntawm nws cov kev sib pauv. thaub qab [noun] Ib daim qauv ntawm cov ntaub ntawv uas tuaj yeem siv los kho thiab rov qab cov ntaub ntawv tom qab ua tsis tiav. Thaub qab ntawm a database kuj tseem siv tau los kho ib daim ntawv theej database mus rau qhov chaw tshiab.

Ib sab saum toj no, log backup hauv SQL Server yog dab tsi? SQL ntawv Kev lag luam Log Backups . Ib qho kev lag luam log backup kev ua haujlwm thaub qab ntawm kev lag luam cov ntaub ntawv uas muaj cov ntaub ntawv ntawm txhua qhov kev cog lus thiab tsis tau cog lus. Tom qab lub database tsis ua hauj lwm, koj tuaj yeem khiav qhov kev hloov pauv log backup rov qab tau cov ntaub ntawv mus rau qhov tsis ua hauj lwm.

Yog li ntawd, dab tsi yog hom thaub qab hauv SQL Server?

Cov no yog ntau hom thaub qab SQL Server tso cai:

  • Thaub qab tag nrho.
  • Differential thaub qab.
  • Transaction Log Backup.
  • Tail-Log thaub qab.
  • Cov ntaub ntawv thiab Filegroup Backup.
  • Ib nrab thaub qab.
  • Luam-tsuas thaub qab.

Muaj pes tsawg hom thaub qab muaj?

Txhua thaub qab program muaj nws tus kheej mus kom ze nyob rau hauv executing lub thaub qab , tab sis muaj plaub yam hom thaub qab siv thiab feem ntau siv nyob rau hauv feem ntau ntawm cov kev pab cuam no: tag nrho thaub qab , sib txawv thaub qab , nce ntxiv thaub qab thiab daim iav thaub qab.

Pom zoo: