Pro SQL Server 2008 Mirroring

This book on mirroring complements Apress's upcoming book on failover clustering. Taken together, the books deliver the most authoritative content for those charged with the demanding task of keeping their SQL Server databases up and running all of the time.

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond.

• Easy to follow, step-by-step instructions for beginner and intermediate users
• In-depth, detailed information for advanced and expert users

• Covers all phases of database mirroring from planning to sustained maintenance

  Part of Apress' one-two punch into SQL Server high-availability, along with our upcoming book on clustering The first book to market on its topic Focused and deep, exceeding what the competition can offer

  Autorentext
  Robert L. Davis is a database administrator and data architect consulting at Microsoft who has worked extensively in setting up and creating automated processes to manage database mirroring for many internal Microsoft applications. He additionally consults with various internal Microsoft IT groups to assist them with their database mirroring needs. Robert is currently working on the Architecture & Performance Engineering team of the CAP application program group. CAP is the internal software used by support personnel for all of Microsoft's customer facing products such as Xbox, Zune, MSN, Microsoft Live, and HotMail. He has over eight years of SQL Server administration experience, much of that in high-availability environments. Rob writes frequently about mirroring and related topics in his blog: www.sqlservercentral.com/blogs/robert_davis/default.aspx

  Klappentext

  Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond. Easy to follow, step-by-step instructions for beginner and intermediate users In-depth, detailed information for advanced and expert users Covers all phases of database mirroring from planning to sustained maintenance

  Inhalt
  High-Availability Options.- Database Mirroring Overview.- Planning and Best Practices.- Database Mirroring Setup.- Automating Setup.- Maintenance Simplified.- Monitoring and Alerting.- Upgrading to SQL Server 2008.- Reporting Considerations.- Planning for Failure.