August 23, 2011 at 8:30 am
I have an 8-day expiration set for the Full, Diff and Trx backups plans. I still get more than 8 days of jobs acccruing in the backup directory. There must be another setting I'm missing? If this is just for overwrite permission, how do I prune the backup directory outside of the manula process I'm doing now?
August 23, 2011 at 8:31 am
eelliott 75257 (8/23/2011)
I have an 8-day expiration set for the Full, Diff and Trx backups plans. I still get more than 8 days of jobs acccruing in the backup directory. There must be another setting I'm missing? If this is just for overwrite permission, how do I prune the backup directory outside of the manula process I'm doing now?
Outside of the MaintProcess use XP_Cmdshell and forfiles
C:\>forfiles /?
FORFILES [/P pathname] [/M searchmask] [/S]
[/C command] [/D [+ | -] {MM/dd/yyyy | dd}]
Description:
Selects a file (or set of files) and executes a
command on that file. This is helpful for batch jobs.
Parameter List:
/P pathname Indicates the path to start searching.
The default folder is the current working
directory (.).
/M searchmask Searches files according to a searchmask.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
August 23, 2011 at 8:33 am
Does SQL not provide for this within the Maint process?
August 23, 2011 at 11:05 am
eelliott 75257 (8/23/2011)
Does SQL not provide for this within the Maint process?
I don't use maintanence plans, but last I remember (SQL 2000) they had the ability to remove files older than n days
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply