Microsoft SQL Server 2000 High Availability

The essential guide for delivering enterprise-level, high-availability solutions with SQL Server 2000 Ensuring 24/7 database availability is crucial to your company’s success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000–based systems up and running—and secure—with the expertise of those who know the technology best. This in-depth guide from Microsoft Press is written by the authors of the Microsoft SQL Server 2000 Resource Kit and the SQL Server 2000 high availability boot camp—the Microsoft consultants who work with customers and the technology every day. Database administrators, network and security administrators, and other IT professionals will learn how to implement best practices for designing, managing, and troubleshooting high-availability solutions and see case studies that illustrate how the strategies and techniques described in the book work in real companies. Topics include balancing scalability, availability, performance, and growth; operating system configuration; RAID; SQL Server failover clustering; log shipping; replication; system monitoring; preventive maintenance and backups; optimizing upgrades; disaster recovery; and more. The companion CD-ROM features administrative scripts, worksheets, checklists, and other useful resources.