Replication Utilities

You can use five utilities to configure and execute the replication functionality of SQL Server. These utilities are covered in more detail in Chapter 22, “Data Replication.” The utilities include the following:

  • Replication Distribution Agent partial syntax:

    distrib -Publisher server_name[\instance_name] 
-PublisherDB publisher_database
-Subscriber server_name[\instance_name]

    The Replication Distribution Agent is a process that transfers the replicated data held at the distributor to the various subscribers.

  • Replication Log Reader Agent partial syntax:

    logread -Publisher server_name[\instance_name] 
-PublisherDB publisher_database

    The Replication Log Reader Agent transfers transactions marked for replication on the publisher ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial