Transactional Replication FAQ
Following are some of the common questions asked by DBAs about SQL Server transaction replication:
| Q1: | How do I change my options for the Distribution Agent? |
| A1: | In the Replication Monitor, you can configure options on all the replication agents. Double-click an agent folder (LogReader, Snapshot, Distribution, Miscellaneous). When the current agents populate the right pane of the Management Console, right-click the one you want to configure. Choose Agent Properties from the shortcut menu. |
| Q2: | How do I unsubscribe from a publication? |
| A2: | The publisher can delete a push or pull subscription from a publication. Expand the Replication folder in Enterprise Manager. Expand the Publications folder and right-click the name ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
