January 21, 2013 at 2:57 am
Hi All,
i have created a Maintenance Plan for daily FULL Backup of 2 databases in a SQL Instance. The Job is taking backup file successfully but not cleaning up the old files. So my Disk is getting filled up with old backup files.
I have included 'Maintenance Cleanup task' in the Plan and the retention period to 2 days. Meaning we do not need any backup files prior to 2 days. Not sure why this is not able to clear the old backup copies.
The intresting thing is, I created a similar Plan on various SQL Instances and but selected default all databases option in the 'Backup Database task'. And it works like a charm.
Can you please suggest what is missing here. and please let me know if you need any information to figure out the bottle neck.
January 21, 2013 at 3:07 am
Have you specified a file extension in your Maintenance Cleanup Task?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
January 21, 2013 at 3:16 am
Yes I did. '.BAK'. Is it case sensitive? should I mention '.bak' instead?
January 21, 2013 at 3:17 am
Remove the dot. So instead of .bak just put bak
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
January 21, 2013 at 3:23 am
actually there was no dot... its just 'BAK' I should not have typed dot while i was replying to you.
January 21, 2013 at 3:26 am
Okay, can I suggest you run process monitor to see what the clean up task is actually doing?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
January 21, 2013 at 5:08 am
what is happening? are you seeing files older than 4 days still there?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply