Exportar (0) Imprimir
Expandir todo

How to: Quiesce a Replication Topology (Replication Transact-SQL Programming)

Quiescing a system involves stopping activity on published tables at all nodes and ensuring that each node has received all changes from all other nodes. This topic explains how to quiesce a replication topology, which is required for a number of administrative tasks, and how to ensure that a node has received all changes from other nodes.

  1. Stop activity on all published tables at the Publisher.

  2. At the Publisher on the publication database, execute sp_posttracertoken (Transact-SQL).

  3. At the Publisher on the publication database, execute sp_helptracertokenhistory (Transact-SQL).

  4. Ensure that each Subscriber has received the tracer token.

  1. Stop activity on all published tables at the Publisher and all Subscribers.

  2. If any Subscribers use queued updating subscriptions:

    1. If the Queue Reader Agent is not running in continuous mode, run the agent. For more information about running agents, see Programming Replication Agent Executables or Cómo iniciar y detener un agente de réplica (SQL Server Management Studio).
    2. To verify that the queue is empty, execute sp_replqueuemonitor (Transact-SQL) at each Subscriber.
  3. At the Publisher on the publication database, execute sp_posttracertoken (Transact-SQL).

  4. At the Publisher on the publication database, execute sp_helptracertokenhistory (Transact-SQL).

  5. Ensure that each Subscriber has received the tracer token.

  1. Stop activity on all published tables at all nodes.

  2. Execute sp_requestpeerresponse (Transact-SQL) on each publication database in the topology.

  3. If the Log Reader Agent or Distribution Agent is not running in continuous mode, run the agent. The Log Reader Agent must be started before the Distribution Agent. For more information about running agents, see Programming Replication Agent Executables or Cómo iniciar y detener un agente de réplica (SQL Server Management Studio).

  4. Execute sp_helppeerresponses (Transact-SQL) on each publication database in the topology. Ensure that the result set contains responses from each of the other nodes.

  1. Execute sp_requestpeerresponse (Transact-SQL) on the publication database at the node you are checking.

  2. If the Log Reader Agent or Distribution Agent is not running in continuous mode, run the agent. The Log Reader Agent must be started before the Distribution Agent. For more information about running agents, see Programming Replication Agent Executables or Cómo iniciar y detener un agente de réplica (SQL Server Management Studio).

  3. Execute sp_helppeerresponses (Transact-SQL) on the publication database at the node you are checking. Ensure that the result set contains responses from each of the other nodes.

  1. Stop activity on all published tables at the Publisher and at all Subscribers.

  2. Run the Merge Agent for each subscription two times: synchronize all subscriptions once and then synchronize each subscription a second time. This ensures that all changes are replicated to all nodes. For more information about running agents, see Programming Replication Agent Executables or Cómo iniciar y detener un agente de réplica (SQL Server Management Studio).

    ms147385.note(es-es,SQL.90).gifNota:
    If conflicts occur during synchronization, it is possible that changes required by conflict resolution will not be propagated to all nodes after running the Merge Agent two times.

Adiciones de comunidad

AGREGAR
Mostrar:
© 2014 Microsoft