Administering and Monitoring Replication (Transact-SQL)

How to Install SQL Server 2000

How To

Administering and Monitoring Replication (Transact-SQL)

SQL Server replication provides tools to administer and monitor replication agents, replication alerts, and replication processes so that you can ensure that replication is meeting the needs of your applications and your organization.

Monitoring replication will help you:

  • Set the profiles, schedules and notifications for replication agents.

  • Troubleshoot agent activity including verifying when agents last ran, monitoring agent activity.

  • Troubleshoot agent errors.

Ensure that data values are the same at the Publisher and at Subscribers.