| Get the definitive reference to maximizing the availability of your critical, SQL Server 2000-based business systems. Developed by Microsoft field consultants who create and support high availability solutions every day, this practical guide explains how to plan, design, implement, and support highly available SQL Server 2000-based systems for both 32-bit and 64-bit environments. You get in-depth, end-to-end guidance—from evaluating availability requirements and capacity planning to implementing failover clustering, log shipping, replication, system backup and restore, system recovery, and other technologies and processes. Real-world scenarios illustrate the book’s best practices in action.
Discover how to:
- Evaluate technical, staffing, and budget requirements
- Plan and configure disk subsystems for performance and availability
- Configure Microsoft Windows 2000 Server of Microsoft Windows Server—2003 to optimize SQL Server 2000 availability
- Plan, implement, and maintain a base server cluster and Network Load Balancing
- Plan and configure failover clustering
- Use built-in log shipping features or code your own
- Create comprehensive backup and restore plans
- Choose replication methods for high-availability—and expose replication architecture
- Develop prevention and disaster recovery strategies
- Minimize downtime for server upgrades and service pack installations
- Establish baseline performance and use availability-monitoring tools and techniques
|
|
|
|