Could anyone help explain the below as it's been on my mind for some time.
When we add a new article to a publication what is the difference in running the snapshot agent in replication monitor to kick start a new snapshot to deliver all tables v.s. why/when would you right click a publication and 'Reinitialize All Subscriptions'
then right click the snapshot agent and run it? Is it all down to the snapshot retention/expiration date set? If so I can't say I've ever had an issue with not doing a full reinitialize.
