Pro SQL Server 2008 Mirroring (Expert's Voice in SQL Server) [Paperback]

Robert Davis (Author), Ken Simmons (Author)

Book Description

Publication Date: October 7, 2009 | ISBN-10: 1430224231 | ISBN-13: 978-1430224235 | Edition: 1

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

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

Product Details

• Paperback: 400 pages
• Publisher: Apress; 1 edition (October 7, 2009)
• Language: English
• ISBN-10: 1430224231
• ISBN-13: 978-1430224235
• Product Dimensions: 7.5 x 0.5 x 9.2 inches
• Shipping Weight: 10.6 ounces (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #1,106,888 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

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

Ken Simmons is a database administrator and developer specializing in Microsoft SQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005.

Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed an SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.

Product Details

• Paperback: 400 pages
• Publisher: Apress; 1 edition (October 7, 2009)
• Language: English
• ISBN-10: 1430224231
• ISBN-13: 978-1430224235
• Product Dimensions: 7.5 x 0.5 x 9.2 inches
• Shipping Weight: 10.6 ounces (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #1,106,888 in Books (See Top 100 in Books)

Most Helpful Customer Reviews

2 of 4 people found the following review helpful

5.0 out of 5 stars Great Guide for Database Mirroring October 15, 2009

By Glenn Berry

Format:Paperback

Database Mirroring was added to SQL Server 2005, and improved in SQL Server 2008, yet many database administrators are still unfamiliar with the technology. This book is full of very useful information on how to create database mirrors and how to monitor and maintain them, using both T-SQL and PowerShell scripts.

I was the technical reviewer for the book. I wish I had a book like this when I first started using database mirroring on SQL Server 2005 back in early 2006. Database mirroring is a good alternative to fail-over clustering or log shipping in many situations. The book is short enough that you will actually be more likely to completely read it.

[...]