Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server 2000 Maintenance plans

Author  Topic 

itsonlyme4
Posting Yak Master

109 Posts

Posted - 2014-03-24 : 05:51:16

Puzzled about this. I am running daily backups for 3 Databases in a SQL Server 2000 Instance. I am using the built-in maintenace plans.

When I setup the backup - I am checking the box to delete Backups older than (1) days and backup extension BAK.

The backup runs but does not delete the older backups in the folder.

I have checked the System event logs as well as the SQL Server log and I do not see any errors and the backup runs fine, it just does not delete the older backups. I have other sql server 2000 instance where this is working. This has worked in the past for the SQL Server Instance in question - does anyone have a clue as to why this has stopped working?
   

- Advertisement -