By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
We are running SQL Server 2000 (SP3a) on a Windows 2000 Server (SP4). I have set up each of our five databases on separate maintenance plans, which are set to back up the database and transaction log each night and remove the previous backup set. Unfortunately, I have two problems. First, on one of the databases, the transaction log never backs up. Second, on two of the other databases, it keeps two backup sets instead of just the one set defined in the maintenance plan. The remaining two databases backup normally. I have checked the maintenance plans and they are all set to backup the transaction logs, and also to remove backups older than one day.
I am not aware of any issues of this sort with the SQL Server 2000 maintenance plans. I have not seen any information directly from Microsoft nor experienced the problem first hand. Since the issues are not consistent, I would recommend disabling the current SQL Server jobs and then recreate the SQL Server jobs via the maintenance wizard. Review the output the following day to determine if recreating the jobs has solved the problems.