SQL Server Alwayson Revealed

Peter A. Carter (Autor)

Buch | Softcover

212 Seiten

2016 | 2nd Revised edition
Apress (Verlag)
978-1-4842-2396-3 (ISBN)

Infos

• Covers a new and high-end feature set that is sweeping the user community
• Provides a quick start to 24x7 availability in support of enterprise applications
• Helps database administrators ensure their ability to recover from data loss

---

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata.

The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable.

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 in SQL Server 2016
Build and configure a Windows Cluster
Create and configure an AlwaysOn failover clustered instance
Implement AlwaysOn Availability Groups and appropriately configure them
Administer AlwaysOn technologies post implementation
Troubleshoot and resolve problems with misbehaving systems

This Book is for Database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.

Autor

Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and it sits alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005 onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.

Inhalt

1. High Availability and Disaster Recovery Concepts2. Understanding High Availability and Disaster Recovery Technologies3. Implementing A Cluster4. Implementing an AlwaysOn Failover Clustered Instance5. Implementing HA with AlwaysOn Availability Groups6. Implementing DR with AlwaysOn Availability Groups7. Administering AlwaysOn8. Monitoring AlwaysOn Availability Groups9. Troubleshooting AlwaysOn

Produkt-Details

• Erscheinungsdatum: 16.12.2016
• Zusatzinfo: 112 colour illustrations, biography
• Verlagsort: Berkley
• Sprache: englisch
• Maße: 155 x 235 mm
• Gewicht: 361 g
• Einbandart: kartoniert
• Themenwelt: Informatik ► Betriebssysteme / Server ► Windows Server
• Themenwelt: Informatik ► Datenbanken ► SQL Server
• Schlagworte: 24x7 • Always On • AlwaysOn • Availability Groups • Disaster Recovery • Failover • Failover Cluster • high-availability • Log Shipping • MIRRORING • Recovery Point Objectives • Recovery Time Objectives • SQL Server • Standby • Standby Server • Windows Cluster
• ISBN-10: 1-4842-2396-9 / 1484223969
• ISBN-13: 978-1-4842-2396-3 / 9781484223963
• Zustand: Neuware