Category: replication

Allow cleanup for snapshot replication

When you setup SQL Server replication via snapshots, a new job is created on the distributor: 'Distribution clean up: distribution' This calls a job dbo.sp_MSdistribution_cleanup that will clean up the records from the MSrepl_commands and MSrepl_transactions tables. What I didn't know was that it  also deletes any expired snapshots stored in the Replication folder. For this process to work 3...