Book Image

SQL Server on Azure Virtual Machines

By : Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West
Book Image

SQL Server on Azure Virtual Machines

By: Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West

Overview of this book

Deploying SQL Server on Azure virtual machines allows you to work on full versions of SQL Server in the cloud without having to maintain on-premises hardware. The book begins by introducing you to the SQL portfolio in Azure and takes you through SQL Server IaaS scenarios, before explaining the factors that you need to consider while choosing an OS for SQL Server in Azure VMs. As you progress through the book, you'll explore different VM options and deployment choices for IaaS and understand platform availability, migration tools, and best practices in Azure. In later chapters, you'll learn how to configure storage to achieve optimized performance. Finally, you'll get to grips with the concept of Azure Hybrid Benefit and find out how you can use it to maximize the value of your existing on-premises SQL Server. By the end of this book, you'll be proficient in administering SQL Server on Microsoft Azure and leveraging the tools required for its deployment.
Table of Contents (10 chapters)
8
Index

What is disaster recovery?

When disaster strikes, your job as a SQL Server database administrator is to ensure business continuity by recovering the data estate to a previously known good state, in as short a time as possible. Disaster recovery is your organization's insurance policy and relies on support from the organization as well.

Note

A disaster is any event that causes an unplanned interruption in business continuity through unrecoverable failure.

At all times, remember that high availability is not disaster recovery. You're considering what happens when high availability could also fail, even if it makes use of the same underlying technology.

A good disaster recovery plan starts with a healthy database. You can make use of the maintenance features inside SQL Server, including maintenance plans with SQL Agent inside SQL Server Management Studio and Azure Data Studio, PowerShell cmdlets, from the command line using SQLCMD, and those provided by third parties...