In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication without initializing old articles, I mentioned about one of the very critical parameters to consider is the immediate_sync in the Transactional Replication. Let’s understand both the options of the parameter. When you say; immediate_sync= true It […]

Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the existing publication, and you would like to initialize only the newly added article instead of all articles in the publication. To achieve the above requirement, I will be using below-mentioned Publisher Server, Publication Database, and Subscriber […]

Whenever there is a business requirement to add a new article to an existing publication, you want to know how the publication is going to behave during the initialization. Basically, you start asking following questions to yourself; Will a new snapshot (running the snapshot agent of the publication) cause to initialize\reinitialize to all the articles […]