SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

itsonlyme4
Yak Posting Veteran

93 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  
 New 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.03 seconds. Powered By: Snitz Forums 2000