dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72 ??

  • Hi

    Sorry for the upcoming vagueness....

    I have a replication job and have recently run out of space because the snapshot grew and the REPLDATA folder kept too many copies of the replication

    Not sure how this works but it seems to keep 14 occurrences

    Now the snapshot is done once daily and copies the entire DB for reporting purposes

    I actually only need maybe 2 copies, because in reality the data will be too old to restore after that anyway.

    Any insight on this would help greatly

    Thanks

    Joe

  • I think what you are looking to do is decrease the retention timeframe.... from 72 hours to.... maybe 24 hours.....

  • Thanks for the response...

    I am going to give it a try , any idea why it still would have older snapshots like 12/24/13 ?

    is it maybe a permissions on the folder?

    Thanks

    Joe

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

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