Old backup files are not being deleted - by Andy_T

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


0
0
Sign in
to vote
ID 305550 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/18/2007 9:28:47 AM
Access Restriction Public

Description

SQL 2008 CTP5 - October Release

I have two maintenance plans as follows:

User Databases - Backup all non system databases

System Databases - Backup all system databases, delete all .bak files older than 4 days, delete all .trn files older than 4 days, delete all .txt files older than 14 days

All .bak and .trn files are backed up to and deleted from the same folder at J:\MSSQL\sqlbackups

Here is a printout of my .bak files (I am not currently backing up any logfiles). Notice for all system databases there are only 5 files present, however for the CPAC and ReportServer backup files there are 8 each. It seems that my cleanup tasks are correctly deleting old system backups but my user backups are being ignored.


CPAC_backup_200710110202.bak
CPAC_backup_200710120202.bak
CPAC_backup_200710130200.bak
CPAC_backup_200710140200.bak
CPAC_backup_200710150200.bak
CPAC_backup_200710160200.bak
CPAC_backup_200710170200.bak
CPAC_backup_200710180200.bak
master_backup_200710140100.bak
master_backup_200710150100.bak
master_backup_200710160100.bak
master_backup_200710170100.bak
master_backup_200710180100.bak
model_backup_200710140100.bak
model_backup_200710150100.bak
model_backup_200710160100.bak
model_backup_200710170100.bak
model_backup_200710180100.bak
msdb_backup_200710140100.bak
msdb_backup_200710150100.bak
msdb_backup_200710160100.bak
msdb_backup_200710170100.bak
msdb_backup_200710180100.bak
ReportServer_backup_200710110202.bak
ReportServer_backup_200710120202.bak
ReportServer_backup_200710130200.bak
ReportServer_backup_200710140200.bak
ReportServer_backup_200710150200.bak
ReportServer_backup_200710160200.bak
ReportServer_backup_200710170200.bak
ReportServer_backup_200710180200.bak


Sign in to post a comment.
Posted by Microsoft on 11/12/2007 at 10:06 PM
Hi Andy-T,
We have fixed this issue and the fix will be available in Katmai-CTP6.
Thanks
Rajesh
Posted by Microsoft on 11/2/2007 at 6:31 AM
Hi Andy-T,
Thanks for reporting this issue. We found the problem happen only with the databases backedup using "backup compression". We will fix this soon and update this space accordingly

Thanks
Rajesh
Posted by Microsoft on 10/31/2007 at 9:24 AM
Hi Andy-T,

Thanks for reporting this issue. We will have a look at this and update this space accordingly.

Regards
Vinod