Cov txheej txheem:

Kuv tuaj yeem tshawb xyuas SQL database replication li cas?
Kuv tuaj yeem tshawb xyuas SQL database replication li cas?

Video: Kuv tuaj yeem tshawb xyuas SQL database replication li cas?

Video: Kuv tuaj yeem tshawb xyuas SQL database replication li cas?
Video: Automation with Adobe Acrobat Pro! Batch Converting PDF Files 2024, Hlis ntuj nqeg
Anonim

Txhawm rau saib xyuas Snapshot Agent thiab Log Reader Agent

  1. Txuas mus rau Publisher hauv Management Studio, thiab tom qab ntawd nthuav tawm server node.
  2. Nthuav cov Rov ua dua folder, thiab tom qab ntawd nthuav lub Local Publications folder.
  3. Right-click ib qho kev tshaj tawm, thiab tom qab ntawd nyem Saib Log Reader Agent xwm txheej los yog Saib Snapshot Agent xwm txheej .

Ntawm no, koj yuav ua li cas thiaj paub yog tias replication ua haujlwm?

Mus xyuas lub rov ua dua tus neeg sawv cev raws li txoj cai, xaiv tus neeg sawv cev tab hauv kev saib ua haujlwm, thiab teeb tsa Cov Haujlwm Saib Xyuas Haujlwm Hom: Hauv qhov no, rov ua dua Cov neeg ua haujlwm tsis ua haujlwm (Tsis yog khiav status), thiab rau kuaj Qhov cuam tshuam ntawm cov ntaub ntawv tso tawm, saib lub sijhawm tshiab tshiab kawg nyob rau sab xis sab xis ntawm lub dialog.

Tom qab, lo lus nug yog, dab tsi yog tus neeg saib xyuas tus neeg saib xyuas ntawm SQL Server? Cov Log Reader Agent . Cov Log Reader Agent yog lub luag haujlwm rau kev hloov pauv cov cim rau kev rov ua dua los ntawm kev hloov pauv log ntawm cov ntaub ntawv luam tawm mus rau cov ntaub ntawv faib khoom. Daim duab 40.20 qhia cov Log Reader Agent (REPL- LogReader qeb npe) rau AdventureWorks2012 database.

Ib yam li ntawd, SQL Server replication yog dab tsi?

SQL Server replication yog ib lub tshuab luam ntawv thiab xa tawm cov ntaub ntawv thiab cov khoom siv database los ntawm ib lub database mus rau lwm qhov thiab tom qab ntawd synchronizing ntawm databases kom muaj kev sib luag thiab kev ncaj ncees ntawm cov ntaub ntawv. Feem ntau, rov ua dua yog tus txheej txheem ntawm rov tsim cov ntaub ntawv ntawm lub hom phiaj xav tau.

Kuv yuav pib Log Reader Agent hauv SQL Server li cas?

Txhawm rau pib thiab nres tus neeg saib xyuas Snapshot, Tus Neeg Saib Xyuas Tus Neeg Sau Npe, lossis Queue Reader Agent los ntawm Replication Monitor

  1. Nthuav ib pab Publisher nyob rau sab laug pane, nthuav ib tug Publisher, thiab ces nias ib tug tshaj tawm.
  2. Nyem qhov Agents tab.
  3. Right-click tus neeg sawv cev, thiab tom qab ntawd nyem Start Agent lossis Stop Agent.

Pom zoo: