Replication and SQL Server Enterprise Manager

SQL Replication


Replication and SQL Server Enterprise Manager

You can use SQL Server Enterprise Manager to implement, administer, and monitor a complete replication environment across your enterprise.

SQL Server Enterprise Manager provides the Replication folder as a central location to organize and administer your publications and subscriptions. If you have heterogeneous publishing services from Microsoft or other companies installed, the Heterogeneous Replication folder will appear under the Replication folder as a location to manage publications and subscriptions based on heterogeneous data sources.

Replication Monitor

Through Replication Monitor, you can view and manage replication agents responsible for various replication tasks. Replication Monitor appears as a node below the Replication folder in SQL Server Enterprise Manager on the Distributor after you have configured publishing and distribution.

For example, using Replication Monitor, you can set up replication so that the Publisher log is read continuously, transactions are distributed to Subscribers every ten minutes, and initial snapshots are generated every night at midnight. You can also execute replication agents on demand.

Replication Monitor provides a way to set alerts on replication events. When the event occurs, Replication Monitor responds automatically, either by executing a task that you have defined or by sending an e-mail or a pager message to a specified individual.

Events in the task history can also be written to the Microsoft Windows NT® 4.0 or Windows 2000 application log if the task is set to use Windows NT logging, and can be viewed by using Event Viewer. For information about using Event Viewer, see Windows NT 4.0 or Windows 2000 Help.

SQL Server Agent is an internal SQL Server 2000 tool that hosts and schedules the agents used in replication, and provides an easy way to run replication agents. SQL Server Agent also controls and monitors several other operations outside of replication including monitoring the SQLServerAgent service, maintaining error logs, running jobs, and starting other processes.

Another tool accessible through SQL Server Enterprise Manager is the replication Conflict Viewer. The Conflict Viewer helps you view and resolve conflicts that occurred during the merge replication or queued updating process.

See Also

Administering and Monitoring Replication

Merge Replication Conflict Detection and Resolution

Queued Updating Conflict Detection and Resolution