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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server 2000 Maintenance plans
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

109 Posts

Posted - 03/24/2014 :  05:51:16  Show Profile  Reply with Quote

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?
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000