SQL Server Cannot Reinitialize Subscriptions of non-immediate_sync Publications
Sometimes when trying to initialize a subscription on a SQL Server database that is involved in a replication topology, you could run into the following error message:
Cannot reinitialize subscriptions of non-immediate_sync publications
Change database context to ‘[db-name]‘.
A pretty nasty message that means very little.
I am not 100% certain what non-immediate_sync value exactly controls in a replication topology, but from what I gather, the story goes like this…
non-immediate_sync is a flag (TRUE/FALSE) on the dbo.MSreplication_subscriptions table that exist in the System Tables folder for a subscriber database (in a replication topology), the flag when set to TRUE (or 1) indicates that a subscription agent can request from the distributor database to be initialized, when FALSE (or 0) it indicates that a subscription cannot make such request, and has to wait until the distributor triggers an initialization.
In any case, to resolve this issue the table you need to look at in the distributor database is:
System Tables > dbo.MSreplication_subscriptions
so on the subscription database…
There should be a column called immediate_sync within this table, the value of this column for the subscription you are trying to initialize will be FALSE, you will need to change this to TRUE.
immediate_sync replication option.png
Now you should be alright trying to initialize the replication subscription.
for more information on this you could visit this general replication forum.
Leave a ReplyWant to join the discussion?
Feel free to contribute!