x

login about faq Site discussion (meta-askssc)

Change the cleanup cycle in Distribution clean up:distribution

0

Can I change EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72 to EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 12 so that cleanup will take place every 12 hrs and my network drive does not get filled up.

asked Sep 18 '12 at 01:26 PM in Default

Chitrarekha
140 ● 5 ● 21 ● 38

(comments are locked)

1 answer:

0

I have had to do this once or twice before. As the post below states, please test first

Use this post a reference..

answered Sep 18 '12 at 07:17 PM

sp_lock
8.1k ● 20 ● 26 ● 29

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

replication x237

asked: Sep 18 '12 at 01:26 PM

Seen: 240 times

Last Updated: Sep 18 '12 at 07:17 PM

Related Questions

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.