Dab tsi yog cov ntaub ntawv khaws cia hauv SQL Server?
Dab tsi yog cov ntaub ntawv khaws cia hauv SQL Server?

Video: Dab tsi yog cov ntaub ntawv khaws cia hauv SQL Server?

Video: Dab tsi yog cov ntaub ntawv khaws cia hauv SQL Server?
Video: Kev Muag Khoom thiab Kev Sib Cuam Tshuam Nrog Cov Neeg Qhua Yam Muaj Kev Nyab Xeeb 2024, Lub peb hlis ntuj
Anonim

Siv cov SQL neeg rau zaub mov database khaws cia feature rau archive ib SQL ntawv rooj, raws li qhov tshwj xeeb archival yam. Cov txheej txheem archive exports cov ntaub ntawv los ntawm qhov chaw database mus rau staging database. Lub staging database yuav tsum nyob ntawm qhov sib txawv SQL Server piv txwv ntawm tib neeg lossis lwm tus neeg siv khoom.

Kuj paub yog, cov ntaub ntawv archive yog dab tsi?

Cov ntaub ntawv archiving yog tus txheej txheem txav cov ntaub ntawv uas yog tsis nquag siv rau ib qho chaw cia khoom cais kom khaws cia mus ntev. Cov ntaub ntawv khaws cia muaj cov laus cov ntaub ntawv uas tseem tseem ceeb rau lub koom haum los yog yuav tsum tau khaws cia rau yav tom ntej siv los yog kev cai ua raws li cov laj thawj.

Kuv yuav khaws ib lub rooj hauv SQL li cas? Ntawm Cov Ntsiab Lus tab, muab cov ntaub ntawv rau cov ntaub ntawv database uas koj xav khaws cia:

  1. Los ntawm cov npe Database, xaiv SQL database uas koj xav khaws cia.
  2. Nyem Ntxiv Lub Hom Phiaj.
  3. Los ntawm Xaiv Archiving Target Table seem, xaiv ib lub schema thiab ib lub rooj archiving lub hom phiaj.

Yog li ntawd, kuv yuav khaws cia hauv SQL Server li cas?

Archiving SQL Server cov ntaub ntawv. Lwm txoj hauv kev ua qhov no yog los ntawm kev siv SWITCH hais kom ua hauv qhov muab faib. Rau khaws cia cov ntaub ntawv siv SWITCH hais kom ua, koj yuav tsum tsim tib lub rooj qauv hauv tib cov ntaub ntawv pawg raws li qhov muab faib uas koj tab tom yuav. khaws cia raws li qhia hauv qab no. Tom ntej no yog hloov cov ntaub ntawv mus rau lub rooj tsim tshiab.

Dab tsi yog cov ntaub ntawv purging hauv SQL Server?

Kev tshem tawm cov ntaub ntawv yog rho tawm cov ntaub ntawv uas koj tsis xav tau lawm. Hauv SQL Server 2000, los yog qhov tseeb hauv ib qho twg database system, thawj kauj ruam yog kom paub tseeb tias koj muaj ib daim qauv ntawm nws, vim hais tias tej zaum koj yuav xav rov qab rau ib hnub. Muaj ntau txoj hauv kev kom paub tseeb tias koj muaj daim ntawv luam ntawm koj tus kheej cov ntaub ntawv.

Pom zoo: