synchronizing expired subscription and publication databases
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.
The expired subscription will need to be reinitialized from the publication snapshot. Few ways to not lose the subscriber data (not yet synchronized to Publisher) is to 1. store the data in temporary tables and then after reinitializing, move the rows from the temp tables to the subscriber and then sync again.
2. Re-create the subscription with no-sync option.
Also please refer to BOL topic:
A Merge Subscription Has Expired and Changes Must Be Uploaded
under:
Configuring and Maintaining Replication --> Troubleshooting Replication --> Troubleshooting Guidance for Replication Issues