March 18, 2009 at 8:44 am
Hello all,
For some reason, my maintenance plan for a single database fails once a week. I know that it is due to the lack of disk space, as the partition only has room for about 2 BAK files and no more. (~80 GB)
Every Wednesday, when I go to the location where the BAK files are store, there are two files there. For the other six days of the week, the maintenance plan works fine and there are no errors. It appears as if the BAK file deletion fails once a week or, for some reason, two BAK files for that database are written in the same 24hr period and the cleanup leaves both due to the same datestamp.
Any ideas are appreciated.
Thanks,
Bernard
March 18, 2009 at 6:26 pm
I have had issues like that it turned out to be time difference; check out how long it takes to complete backup. If one of the times the backups finished earlier the then previous day then the 1-day limit has not been reached so the backup doesn't delete.
So we set our backups to delete older then 20 hours; thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 19, 2009 at 7:21 am
Mohit,
I believe you're right. I looked in the maintenance log file at the BAK file deletion times right posting and there seems to be varying times for the deletions.
I'm going to make the deletion time < 24 hours as you suggested. I'm quite confident that will solve the issue.
Thank you,
Bernard
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply