Distribution Clean Up: Removes replicated transactions from Runs every ten Distribution the distribution database. Deactivates minutes subscriptions that have not been synchronized within the maximum distribution retention period. Expired Subscription Up Detects and removes expired Runs every day at subscriptions from publication 1:00 A.M. databases. Reinitialize Subscriptions Detects all subscriptions that have data No default Having Data Validation Failures validation failures and marks them for schedule (not re-initialization. The next time the enabled by Merge Agent or Distribution Agent default). runs, a new snapshot will be applied at the Subscribers. Replication Agents Checkup Detects replication agents that are not Runs every ten actively logging history. It writes to the minutes. Microsoft Windows event log if a job step fails. Replication monitoring Refreshes cached queries used by Runs continuously. refresher for distribution Replication Monitor. Virtual Publisher level structure Virtual Subscriber level structure
Distribution Clean Up: Distribution Removes replicated transactions from the distribution database. Deactivates subscriptions that have not been synchronized within the maximum distribution retention period. Runs every ten minutes Expired Subscription Up Detects and removes expired subscriptions from publication databases. Runs every day at 1:00 A.M. Reinitialize Subscriptions Having Data Validation Failures Detects all subscriptions that have data validation failures and marks them for re-initialization. The next time the Merge Agent or Distribution Agent runs, a new snapshot will be applied at the Subscribers. No default schedule (not enabled by default). Replication Agents Checkup Detects replication agents that are not actively logging history. It writes to the Microsoft Windows event log if a job step fails. Runs every ten minutes. Replication monitoring refresher for distribution Refreshes cached queries used by Replication Monitor. Runs continuously. Virtual Publisher level structure Virtual Subscriber level structure
SQLServer2014ReplicationMPGuide.docx