Manage Learn to apply best practices and optimize your operations.

SQL Server 2000 maintenance plan

Can you tell me what type of locks and other information maintenance plans need when running against a SQL Server 2000 database? I am looking for the internals of how the maintenance plan works.
When creating a maintenance plan, SQL Server jobs are created that break down the maintenance tasks selected into multiple jobs. The jobs then use the sqlmaint utility to complete the task. The tasks that can be run using the sqlmaint utility include database and log backups, DBCC CHECKDB and index rebuilds. These tasks have been written in SQL Server, so they can be run during normal user activity on the database, but locks are applied that can conflict.

So when scheduling any of these tasks, it is a good idea to run these during low usage time. The only real difference would be running transaction log backups. These should be scheduled to run on a schedule that will help minimize data loss.

Do you have comments on this Ask the Expert Q&A? Let us know.

Dig Deeper on SQL Server Backup and Recovery

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.