Professional SQL Server High Availability and Disaster Recovery

Professional SQL Server High Availability and Disaster Recovery
Author :
Publisher : Packt Publishing Ltd
Total Pages : 564
Release :
ISBN-10 : 9781789800814
ISBN-13 : 1789800811
Rating : 4/5 (811 Downloads)

Book Synopsis Professional SQL Server High Availability and Disaster Recovery by : Ahmad Osama

Download or read book Professional SQL Server High Availability and Disaster Recovery written by Ahmad Osama and published by Packt Publishing Ltd. This book was released on 2019-01-31 with total page 564 pages. Available in PDF, EPUB and Kindle. Book excerpt: Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable network of systems. Key FeaturesExplore more than 20 real-world use cases to understand SQL Server featuresGet to grips with the SQL Server Always On technologyLearn how to choose HA and DR topologies for your systemBook Description Professional SQL Server High Availability and Disaster Recovery explains the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You’ll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this book, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. Note that this course does not cover SQL Server Failover Cluster Installation with shared storage. By the end of the book, you’ll be equipped with all that you need to know to develop robust and high performance infrastructure. What you will learnConfigure and troubleshoot Replication, AlwaysOn, and Log ShippingStudy the best practices to implement HA and DR solutionsDesign HA and DR topologies for the SQL Server and study how to choose a topology for your environmentUse T-SQL to configure replication, AlwaysOn, and log shippingMigrate from On-Premise SQL Server to Azure SQL DatabaseManage and maintain AlwaysOn availability groups for extended database mirroringWho this book is for Professional SQL Server High Availability and Disaster Recovery is for you if you are a database administrator or database developer who wants to improve the performance of your production environment. Prior experience of working with SQL Server will help you get the most out of this book.


Professional SQL Server High Availability and Disaster Recovery Related Books

Professional SQL Server High Availability and Disaster Recovery
Language: en
Pages: 564
Authors: Ahmad Osama
Categories: Computers
Type: BOOK - Published: 2019-01-31 - Publisher: Packt Publishing Ltd

GET EBOOK

Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable network of systems. Key FeaturesExplore mo
Pro SQL Server Always On Availability Groups
Language: en
Pages: 316
Authors: Uttam Parui
Categories: Computers
Type: BOOK - Published: 2016-10-24 - Publisher: Apress

GET EBOOK

This book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is
SQL Server 2019 AlwaysOn
Language: en
Pages: 210
Authors: Peter A. Carter
Categories: Computers
Type: BOOK - Published: 2021-02-07 - Publisher: Apress

GET EBOOK

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 ed
Pro SQL Server 2008 Failover Clustering
Language: en
Pages: 420
Authors: Allan Hirt
Categories: Computers
Type: BOOK - Published: 2009-06-29 - Publisher: Apress

GET EBOOK

Pro SQL Server 2008 Failover Clustering is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations. Whether d
Pro SQL Server on Linux
Language: en
Pages: 622
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2018-10-27 - Publisher: Apress

GET EBOOK

Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be