Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72 ?? Expand / Collapse
Author
Message
Posted Thursday, January 2, 2014 9:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 7:34 AM
Points: 299, Visits: 498
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
Post #1527193
Posted Friday, January 3, 2014 10:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:18 AM
Points: 1,285, Visits: 2,829
I think what you are looking to do is decrease the retention timeframe.... from 72 hours to.... maybe 24 hours.....


Post #1527648
Posted Friday, January 3, 2014 11:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 7:34 AM
Points: 299, Visits: 498
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
Post #1527665
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse