SQL Server AlwaysOn Revealed

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter’s Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime.

Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization.

SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.

  • Teaches you to build HA and DR solutions using the AlwaysOn feature set
  • Provides real-world advice on configuration and performance considerations
  • Demonstrates administrative techniques for the AlwaysOn feature set

What You Will Learn

  • Understand high availability and disaster recovery concepts and terminology.
  • Understand the technologies available, to implement HA and DR.
  • Build and configure a Windows Cluster.
  • Build and configure an AlwaysOn failover clustered instance.
  • Implement AlwaysOn Availability Groups and appropriately configure them.
  • Administer AlwaysOn technologies post implementation.

Who This Book Is For

SQL Server AlwaysOn Revealed is for database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.

 

Author(s): Peter Carter
Publisher: Apress
Year: 2015

Language: English
Pages: 158
Tags: Computer Systems Organization and Communication Networks; Enterprise Architecture

Front Matter....Pages i-xiii
High Availability and Disaster Recovery Concepts....Pages 1-6
Understanding High Availability and Disaster Recovery Technologies....Pages 7-26
Implementing a Cluster....Pages 27-56
Implementing an AlwaysOn Failover Clustered Instance....Pages 57-69
Implementing AlwaysOn Availability Groups....Pages 71-128
Administering AlwaysOn....Pages 129-147
Back Matter....Pages 149-150