Manage Learn to apply best practices and optimize your operations.

Problems on some of the five databases with separate maintenance plans

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.

Dig Deeper on Microsoft SQL Server 2000

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.