What is a “virtual” Subscription in Transactional Replication

The SQL Replication system table syssubscriptions contains one row per published article per subscriber.  Notice the “virtual” subscriber. With the immediate_sync property is set to true, “virtual” subscriptions are created as placeholders for retaining generated snapshot (transactions). These “virtual” subscriptions are activated just like normal subscriptions by the Snapshot agent and are used to track
Read More »