March 8, 2016 at 1:11 pm
We have a maintenance plan which takes backup to the network path.
It selected the option create a sub-directory for each database.
I added maintenace cleanup task and selected include first-level sufolders but looks it is not deleting the older files.
March 8, 2016 at 2:01 pm
Provided you have permission to the remote folder (check your logs); what file extension did you specify? It needs to match the files you intend to delete. Also check the file age option, obviously if it's set for a long period it could be awhile before the files are deleted.
March 8, 2016 at 3:42 pm
Yes. Has the access also the job never failed.
First backup then cleanup the files older than 3 days Extension is bak
March 9, 2016 at 2:26 pm
Please check that the file extension is configured to bak and not .bak - I have made this mistake before and it will prevent the cleanup from working properly.
March 16, 2016 at 4:36 pm
Looks it is working but not sure why some databases has 3 backup files and some are 4 days backup files when I use the retention period delete older than 3 days
March 16, 2016 at 8:30 pm
ramana3327 (3/16/2016)
Looks it is working but not sure why some databases has 3 backup files and some are 4 days backup files when I use the retention period delete older than 3 days
If you're only running the command once at the beginning of the backup run, this is quite possible because the later backups will not yet be old enough when you issue the delete command. It's all a matter of timing.
Also, deleting backups at the beginning can and will be a big problem for you someday. You should never delete a backup until you are sure that you've just created a good backup. Otherwise, if something goes wrong, you could end up with no backups when you can least afford to.
--Jeff Moden
March 17, 2016 at 7:39 pm
Cleanup task is after running after the backup
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply