Q
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.
This was last published in August 2004

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close