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
What you’ll learn
Plan effectively for database mirroring. Learn what questions to ask and what problems to anticipate
Get step-by-step instructions on how to set up database mirroring
Automate the initial setup and the ongoing maintenance of mirrored databases
Monitor database mirroring, detect failures, and generate automated alerts
Build a system that automatically responds to and fixes common problems
Build in support for the missing facets of database mirroring, such as support for cross-database dependencies
Define groups of databases that all fail over together to their mirrors when just one of those databases fails
Create operational processes so that even nontechnical staff can manage mirrored databases