Designed for database administrators and system engineers, this guide provides real-world, task-based information and best practices for the day-to-day management of SQL Server 2000. It draws on the combined knowledge and experience of Microsoft Consulting Services (MCS), Microsoft's Internal Technical Support Group, and the SQL Server Developer Team--illustrating both the theory behind and the field-tested practices for improving database operations. Get specific instructions and recommendations for server monitoring, backup, verification of scheduled events, capacity planning, developer and end user support, and other key procedures--exploiting the lessons learned from real enterprise settings to improve team responsiveness and effectiveness and help avoid common errors. All PATTERNS & PRACTICES guides are--reviewed and approved by Microsoft engineering teams, consultants, partners, and customers--deliver accurate, real-world information that's technically validated and tested.