SQL Server Transactional Replication-Snapshot - Initialization without Snapshot -for existing REPL

Question

Hi,

This is Syed JB, I have an existing Transactional Replication. Unfortunately, for some reasons Replication has been removed for some time.  But, now, we have to rebuild the Transactional Replication. Here is the problem, Subscriber has the historical data and for this I can’t push the snapshot and without the initialization, subscriber subscription status set to PENDING. I have tried to setup by changing the parameter in  create replication scripts, but NO luck.  My replication only delivers INSERT and UPDATE statements only(Not the Full replication)

@allow_anonymous = N'true'/False

@immediate_sync = N'true'/False

@independent_agent = N'true'

So, please suggest me.

Answer 1

Wrong forum.

Resubmit your question in the Q&A community:

Microsoft supported products on Q&A | Microsoft Learn

SQL Server - Microsoft Q&A