Post reply

Snapshot Folder is not deleting automatically in Transactional Replication.

  • January 22, 2021 at 6:24 am

    #3836174

    Hi Team,

    I created transnational replication to replicate the data from one server to other server.I am daily generating snapshot for some of the tables on snapshot folder.But old folders are not getting deleted from snapshot folder.. any thought?

  • January 23, 2021 at 7:10 am

    #3836549

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • January 25, 2021 at 10:19 pm

    #3837372

    Old snapshots are deleted by the distribution cleanup agent. The distribution cleanup job will delete snapshots older than the @max_disretention value. It used to be, haven't tested so may still be true, the snapshot agent will only try once to remove previous files so if it hits an error or the files are locked or something like that they won't get deleted. Check the snapshot agent history to see if any errors are reported. Make sure the distribution cleanup job is running successfully. Make sure SQL Server agent has full rights on the snapshot folder.

    Sue

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply