Pro AlwaysOn for SQL Server 11: High Availability and Disaster Recovery for the DBA

Pro AlwaysOn for SQL Server 11 is your complete guide to planning, using, deploying, and maintaining Microsoft SQL Server AlwaysOn as a high availability solution. Sometimes referred to as HADRON, AlwaysOn protects your database by maintaining one or more duplicate copies of your database for use in the event the primary copy is offline. Furthermore, those copies are readable. You can use them as data sources for reporting and BI applications, reducing the load on your production servers and potentially increasing performance of your OLTP applications. This ability to read from duplicate copies is new in AlwaysOn, and is a significant advantage of AlwaysOn over prior, high-availability solutions such as mirroring and clustering.

Pro AlwaysOn for SQL Server 11 covers the full spectrum of AlwaysOn, from planning through the implementation to maintenance and beyond. You’ll find:

• Easy to follow, step-by-step instructions for beginner and intermediate users
• In-depth, detailed information for advanced and expert users
• Coverage of all phases from planning to sustained maintenance

What you’ll learn

• Proper planning for SQL Server AlwaysOn
• Step by step instructions for deployment
• Database organization into availability groups
• Common troubleshooting steps
• Dynamic Management Views specific to AlwaysOn
• Application development techniques in support of high availability
• Database backup from secondary servers

Who this book is for

Pro AlwaysOn for SQL Server 11 is for SQL Server administrators and Windows Server administrators, who are researching or deploying SQL Server AlwaysOn as a high availability and disaster recovery solution for their databases.  Application developers will also find the book beneficial due to its documentation of the changes that may be required for proper failover in applications.