How to re-initialize SQL Server Merge Replication publication

Step-by-step – SQL Server merge replication re-initialization

1. Connect to publisher instance: CIXSQL01\TOUCHSTORE.

01-connect-to-publisher-instance

2. Click right on Replication folder and click on “Launch Replication Monitor” option.

02-launch-replication-monitor

3. Click right on publication that you want to reinitialize and click on “Generate Snapshot”

03-generate-snapshot

4. After generating the snapshot go back to Local Replication, expand the publication you want to reinitialize, click right on subscription name and select “Reinitialize”.

04-reinitialize

5. Checking Synchronization status, click right on subscription name again and select “View synchronization status”.

05-view-synchronization-status

6. The new window will show the synchronization status. This process may take a few minutes to complete. The time may vary according to the publication size.  Be aware the synchronization process will run continuously do not wait it finish.

06-synchronization-status

7. For more information about the publication status, click right on Replication folder and click on “Launch Replication Monitor” option. After complete the process publication must be without error sign.

07-launch-replication-monitor

Conclusion

And this is how you re-initialize SQL Server Merge replication publication.

Let our expert SQL Server Consulting team handle the technical complexities, so you can focus on driving your business forward with confidence.

Picture of Mark Varnas

Mark Varnas

Hey I'm Mark, one of the guys behind Red9. I make a living performance tuning SQL Servers and making them more stable. I channel my SQL into our SQL Managed Services, SQL Consulting and our internal database products.

One Response

  1. Howdy, Jack. So what happens if, on merge replication, you’ve gone outside the window and the subscriber’s job gets deleted? I tried reinitializing it, but that didn’t do anything. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *