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

Is it supposed to cleanup old snapshot folders for trans replication? Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 12:14 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:34 AM
Points: 158, Visits: 617
I have a server that I'm finding out today that was setup a long time ago with transactional replication and they set it up to run the snapshot agent once a day to refresh the data and then let the log reader keep it going through the day (not sure why). But looks like nothing has ever gone out to cleanup the old snapshot folders that are created each day (all the way back to early 2010). So the question is...as part of the normal setup process for trans rep, is there something that is automatically supposed to clean up that folder or is that a manual thing in which we can write a job?
Post #1426400
Posted Tuesday, March 5, 2013 9:09 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:43 AM
Points: 3,309, Visits: 6,700
There is a job that runs in the Distribution Database that will clean up old snap shots that were created.
If at any time you changed the path of the snapshot location, it might not delete old snap shot folders. Also make sure that the permissions are set correctly on the windows level so that the clean up agent can delete those files.


-Roy
Post #1426884
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse