How to re-initialize SQL Server Merge replication publication

SQL Server Merge Steps

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.

 

Agree? Disagree? Comment below.

 

Mark Varnas

Mark Varnas

I love making performance tuning SQL Servers fast and making them more stable. And I channel that obsession into our SQL Managed Services and new content here. When I'm not writing about SQL, I spend time outside hiking, skiing, mountain biking, or trying a new recipe.

Leave a Reply

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

Call Us Now

Or, Let Us Know How We Can Help

Tight On Time?

Schedule A Call: