Maintenance FAQ
The following are some of the common questions asked by DBAs about SQL Server maintenance:
| Q1: | Who in my organization should be tasked with managing the SQL Server maintenance plan? |
| A1: | If your organization has a designated DBA, he should probably be responsible for the maintenance plan. If not, the LAN manager is probably the next best person. Regardless of who is responsible for the maintenance plan, it is important that the someone is the owner of this plan. SQL Server 2000 still requires day-to-day monitoring. |
| Q2: | Are there any third-party tools that can help automate the maintenance plan? |
| A2: | Yes, most backup products include add-ins that can manage the backup and dbcc portion of the maintenance plan. There are also third-party ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
