Apress Access

Pro SQL Server 2008 Mirroring

By Robert Davis , Ken Simmons

  • eBook Price: $38.99
Buy eBook Buy Print Book

Pro SQL Server 2008 Mirroring Cover Image

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-2423-5
  • User Level: Intermediate
  • Publication Date: October 6, 2009
  • Available eBook Formats: PDF

Related Titles

  • High Performance SQL Server
  • Expert Scripting and Automation for SQL Server DBAs
  • DevOps, DBAs, and DBaaS
  • Securing SQL Server
  • Beginning SQL Server R Services
  • Beginning SQL Queries, 2nd Edition
  • Relational Database Programming
  • Database Systems
Full Description

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

Who this book is for

General audience: Pro SQL Server 2008 Database Mirroring is aimed at SQL Server 2008 database administrators, and especially those who desire to mirror their databases in support of high availability. System administrators and operational engineers who manage Windows Server systems that support mirrored database environments will also find much in the book of interest.

Table of Contents

Table of Contents

  1. High Availability Options
  2. Database Mirroring Overview
  3. Planning and Best Practices
  4. Database Mirroring Setup
  5. Automating Setup
  6. Maintenance Simplified
  7. Monitoring and Alerting
  8. Upgrading to SQL Server 2008
  9. Reporting Considerations
  10. Planning for Failure
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. Pro SQL Server Wait Statistics


      View Book

    2. SQL Server T-SQL Recipes


      View Book

    3. Healthy SQL


      View Book

    4. Expert T-SQL Window Functions in SQL Server


      View Book