Replicated Data was not Deleting

  • Hi,

    In one of my application Server(SQL 2k5)........ Snapshot Replication was configured.

    I am having a issue that ....from last 40 days the old snapshot data which create a folder for every one hour was not deleting (Increased up to 16 GB Daily).

    I had done the following checks :

    1)Replication jobs were running successfully in the publication.

    2)Had queried the count in bath publisher and subscriber and it was ok.

    My question is like :

    why these old snapshot folders are not deleting??

    Is there any cleanup jobs that we can check??

    waiting for your quick reply guys:unsure:

    Thanks in advance

  • Yes, You should have clean up job running on distributor, and check the retention time for the old files.

    EnjoY!

    EnjoY!
  • Hi,

    Thanks for the reply ...

    Can any one tell me how to setup a cleanup job to delete the old Folders / Directories in SQL Server 2005.

    Its urgent plz:ermm:

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

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