Sql-server – SQL Server 2000 Transaction Log DelBkUps 3DAYS not working

database-backupsql server

We have a maintenance plan to do a full backup every night at midnight and a transaction backup every hour.

Both have "Delete backups older than 3 days" checked in the wizard

Here's the SQL from the Job:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 8DBCD331-76C8-4736-87ED-FB840696AE63 -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpLog "T:\SQL Backups" -DelBkUps 3DAYS -CrBkSubDir -BkExt "TRN"'

The full backups seem to be cleaning up correctly. However, I'm seeing Transaction logs going back for weeks and we're having to manually go in and clear space because of this.

Is there any reason why this would happen? Permissions? Job taking to long?

Best Answer

If I remember correctly, that was kind of buggy in SQL Server 2000. Personally I don't set this option in my maintenance plans, I schedule a batch file to delete the backup files after they've been backed up to tape. Maybe these will help:

http://support.microsoft.com/kb/303292

http://www.componentworkshop.com/blog/2009/07/01/sql-server-2005-maintenance-cleanup-task-does-not-delete-backup-files

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic24757.aspx

Related Topic