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

Backup files not deleting when using the SQL Maintenance plan Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 8:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 8:19 AM
Points: 3, Visits: 16
I have created a SQL Server Maintenance plan to first created a backup the databases nightly and then delete any file other than three days. The backups are successfully being created however the backup files older then three days are not being delete. I have done the same simple procedure in the past in other database server it just not working on this one. I am not receiving any fail alerts on any sort. ???
Post #1421687
Posted Tuesday, February 19, 2013 8:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
what options have you set on the cleanup task?

told it to transvers subfolders if you have 1 cleanup task for all database backups?




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421689
Posted Tuesday, February 19, 2013 9:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 8:19 AM
Points: 3, Visits: 16
Below are my settings

Delete files of the following types: Backup files
File Location: "x:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup"
File extension: bak
(Checked) Delete file based on the age of the file at task run time
Delete files older than the following: 3 day(s)
Post #1421698
Posted Tuesday, February 19, 2013 9:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
do all backups, backup to that directory or to subdirectories?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421734
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse