Maintenance Plans Backup Task Does Not Delete Old bak files

Question

Maintenance Plans Backup Task Does Not Delete Old bak files

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

I touched on this problem briefly in an article way back when:

http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp

Shameless plug aside, I would actually recommend you open up the plan and add a Maintenance Cleanup Task and specify to clean up backup files older than your threshold. You have to do it manually, the wizard won't do it.

dbaforever Hall of Fame Points: 3740 More actions · Answer 2

Thank you, Arnold. I will check out your article.

Actuall, I did just that - added a Cleanup task to purge the old files. Shouldn't be necessary though because the backup task offers that option ... which obviously doesn't work reliably.

Thanks. John

Brandon Nelson SSC Veteran Points: 223 More actions · Answer 3

John,

I had problems when the Windows Admin changed the normal system backup time to around the same time as SQL. Then the Windows backup application had a lock on the old backup files and they could not be deleted. Once the Windows backup time was changed back it all worked nicely.

Regards,

Brandon

barry555 SSC Eights! Points: 944 More actions · Answer 4

Hi Aaron,

I checked out your article and noted that someone from the SQL Server team said this would be fixed in SP1. We're now on SP2! Have they said when they will fix this?

Regards,

Barry