Snapshot Agent and applied by the Distribution Agent. As we all know, by default, subscriptions in a SQL Server transactional replication publication are reinitialized with a snapshot, which is generated by the There is no Snapshot agent created in the entire, when you initialize subscription from backup. > Wouldn't there be any use of a snapshot agent once you have replication set up and running? Is there anything I should be aware of using this option as well? Wouldn't there be any use of a snapshotĪgent once you have replication set up and running? I was wondering, why didn't he create a SNAPSHOT AGENT ( Remarked Out) at all even if he was using initialization from backup. I sampled some tables (add/delete) and it was replicating as desired. So following it step by step and after several tries/tweaks, I was able to bring up my TR test in approximately 20 mins. I asked around and I was pointed to the option to initialize subscription from backup.ĭid some research and found this tutorial which was very helpful. On a test environment, I created TR initialization from snapshot on a 15GB DB with 6000+ tables. Our DB is large, 280GB with 6000+ tables. So I decided recreating a transactional replication (TR) from scratch instead of dropping and adding articles when we do our upgrade in the near future.

Raises subscription personal backup