How to re-initialize SQL Server Merge replication publication

How to re-initialize SQL Server Merge replication publication

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.

 

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email