List of Expired Merge Subscribers

I have a setup of merge replication.

Sometimes, subscribers will not be able to sync within the retention period set in the publication.

How can I get a list of expired subscribers to a merge replication?

• Open SQL Server Management Studio

• expand instance of SQL server

• expand Replication Folder

• expand Local Publications

• Right click publication that you want to check for any expired subscriptions and choose 'Launch Replication Monitor'

• expand My publishers, right click on publisher in question and click 'Configure replication alerts'

• Choose 'Replication Warning: Subscription expiration (threshold: expiration) and click Configure

• select Response and check Notify Operator

• Add new operator

This will alert you when you have expired subscriptions. It will show all expired subscriptions in Replication Monitor on the Subscription Watch List Tab. If you set it up correctly, will also give you email alerts.

EDIT:

In order for you to receive emails, database mail must be configured.

• Connect to instance

• expand the management folder in object explorer

• right click on Database Mail and choose configure database mail

• add profile name and click Add to configure email address and email server

• if you don't have an email server you can use google / yahoo /etc.

Hope this helps!!

StackExchange Database Administrators Q#63999, answer score: 3