Microsoft SQL Server(TM) 2000 Operations (Patterns & Practices)

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.