I'm running a SQL Server 2008 R2 server with a publication set up for multiple clients running 2008 SQL Express R2. One of the client subscriptions expired.
What is the easiest way to get this Merge replication going again?
I've attempted re-initializing the subscription which didn't help.
I've deleted the subscription which removed itself from the server and client, then re-created which didn't work. The subscription re-creates, but on the server side simply says "Not Initialized" when looking at the Replication Monitor. The odd part is on the client it says successfully synchronized, but it never goes.
I've completely deleted the database on the client. Then re-created the subscription and re-created the database. No matter what I do, the server never leaves "Not Initialized" and when looking at the properties of the re-created subscription it says "Inactive".
Any advice / assistance would be greatly appreciated.