“This comprehensive coverage will be invaluable to both the new administrator and the experienced database engineer alike. Brian takes his seasoned knowledge and lays it out in a way that is easy to understand and easy to implement.” –Rod Trent, Windows Management MVP
Maintain a reliable, scalable, secure SQL Server 2000 environment. Configure and manage SQL Server 2000 for peak performance and high availability using the undocumented administrative and troubleshooting techniques offered inside this focused reference. SQL Server expert Brian Knight gives you details on system and platform architecture, settings, security, file management, replication, automation, backups, clustering, and restoration. The book also explains how to maximize built-in administrative tools, develop maintenance plans to prevent downtime, and optimize overall system performance. Concise and practical, this essential resource will save you hundreds of hours of troubleshooting time.
Part 1 Managing a SQL Server Environment
Part 2 Tuning SQL Server
Part 3 SQL Server in the Enterprise Environment
Part 4 Appendixes
Index