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

How do I clear out old Backups? Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2012 12:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:42 AM
Points: 41, Visits: 70
I change the days to retain on the Backup job from 14 to 3 before I left last Friday. I come into today and there are 7 days worth on there. What am I missing to get it to auto-clear these older backups? Thanks.
Post #1400332
Posted Wednesday, December 26, 2012 1:06 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 4, 2014 10:09 AM
Points: 2,706, Visits: 3,427
Where exactly are you changing this? In a script? In a maintenance plan package? No matter which one... Please provide details of the script/package. My initial assumption is that you are deleting backup history and not backup files.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1400350
Posted Wednesday, December 26, 2012 1:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:42 AM
Points: 41, Visits: 70
In the Maintenance Plan Back of Database (Full) Task, there is an option Property called RetainDays. Change it, and the summary of the Task changes to Backup set will expire: After (in days) 3. I still have 7 days of Backups however.
Post #1400366
Posted Wednesday, December 26, 2012 2:07 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 19, 2014 7:34 PM
Points: 356, Visits: 925
You want to add a Maintenance Plan Cleanup task instead of adjusting the media-set retention period.
Post #1400369
Posted Wednesday, December 26, 2012 2:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:42 AM
Points: 41, Visits: 70
Scott D. Jacobson (12/26/2012)
You want to add a Maintenance Plan Cleanup task instead of adjusting the media-set retention period.


Thanks
Post #1400373
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse