Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server 200 maintenance plans Expand / Collapse
Author
Message
Posted Monday, March 24, 2014 3:52 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:50 AM
Points: 743, Visits: 1,542

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?



Post #1553936
Posted Monday, March 24, 2014 5:34 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Yes, that is the tricky things in SQL Server 2000. While delete you need to put proper path and extention of file should be BAK not .BAK

Try and update the outcome.


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1553975
Posted Monday, March 24, 2014 5:39 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:50 AM
Points: 743, Visits: 1,542
Thank you.

Tried this again with a new backup path to and ensured that the maintenance plan is using BAK and not .BAK

still does not work. very frustrating.



Post #1553979
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse