Snapshot Replication mu Microsoft SQL Server

SQL Server's snapshot replication teknolojia inokubvumira kuti udzose mashoko ari pakati peSQL Server databases akawanda. Iyi teknolojia ndiyo nzira yakanaka yekuvandudza kushanda uye / kana kuvimbika kwehuwandu hwemashoko enyu.

Pane nzira dzakawanda dzaungashandisa kudzokorora kushandura muSQL Server databases. Semuenzaniso, unogona kushandisa teknolojia iyi yekugoverana nharaunda kune databases iri panzvimbo dzakasara. Izvi zvinovandudza kushanda kwevashandi vekupedzisira nekuisa iyo data munzvimbo yeusitere pedyo navo uye panguva imwechete inoderedza mutoro uri mukati medu network network.

Snapshot Replication for Distributing Data

Iwe unogonawo kushandisa kudzokorora kwekutsvaga kwekuparadzira dheta kumaseva akawanda ezvinangwa zvekutakura-kutengesa. Imwe nzira yakakurumbira yekutsvaga ndeyekuita nheyo yezvinyorwa iyo inoshandiswa pamibvunzo yese yekudzokorora uye ipapo maverengedhi akawandisa pasi anogamuchira zvinyorwa uye anoshandiswa mune imwe nzira yekuverenga kuti ipe ruzivo kune vashandisi uye zvidzidzo. Pakupedzisira, iwe unogona kushandisa kudzokorora kwechirongwa kuti uvandudze data pane server yekuchengetedza kuti iunzwe paIndaneti muitiko iyo primary server inokundikana.

Paunoshandisa kudzokorora kudzokorora, iwe unonyora dhesi rose kubva kuMuparidzi SQL Server kune Shanduro SQL Server (s) panguva imwe chete kana kuti inowanzoitika. Apo Mumiririri anogamuchira zvinyorwa, iyo inodzokorora kopi yayo yose ye data nedzivo dzakagamuchirwa kubva kuMuparidzi. Izvi zvinogona kutora nguva yakareba nematafura makuru uye zvakakosha kuti iwe unonyatsocherechedza nguva yakawanda uye nguva yekuparidzirwa kwechinyorwa.

Somuenzaniso, haungadi kutumira zvinyorwa pakati pemaseva pakati pe data yakabatikana pane imwe nzvimbo yakawanda yakawanda. Zvingava zvakanyanya kuchenjera kutumira mashoko pakati peusiku apo vashandi vari pamba uye bandwidth yakawanda.

Kutanga Snapshot Kudzokorora Ndiro Nhanho Dhatu Dzose

  1. Gadzira muparidzi
  2. Ita bhuku racho
  3. Bhalisa kune bhuku racho

Iwe unogona kudzokorora danho rekupedzisira rekusika mubhadhari kakawanda sezvakakosha kuti ugadzire vese vanyori iwe waunoda. Kudzokorora kwechigadziro chinhu chakasimba chinokubvumira kudhinda dhaka pakati pekuiswa kweSQL Server mubhizimisi rako. Vadzidzisi vanobatanidzwa pamusoro apa vachakubatsira kutanga kutamisa data munyaya yeawa.