Replication reinitialize error

Question

I am getting an error 'Cannot reinitialize subscriptions of non-immediate_sync publications; Microsoft SQL server 21059
Just created a publisher and a subscriber and trying to initialize it and it's giving the error
I am pulling my hair and not able to figure this out.. Appreciate any help

Kumar

Answer 1

Hi @KumarS ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @KumarS ,

...Cannot reinitialize subscriptions of non-immediate_sync publications;...

Quote from this doc.: replication

Cause:

Subscription needs to be reinitialized if any snapshot needs to be applied for any broken replication. In this case Subscriptions cannot be reinitialized for non-immediate_sync publications.

WorkAround:

Connect to the subscriber database, in the Msreplication_subscriptions table; the value of immediate_sync should be changed to 1. 0 indicates non-immediate sync publications...

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Thank you output of select @@version is

Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64)
Dec 28 2017 15:03:48
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)