Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Professional Azure SQL Database Administration
  • Table Of Contents Toc
  • Feedback & Rating feedback
Professional Azure SQL Database Administration

Professional Azure SQL Database Administration

By : Ahmad Osama
5 (2)
close
close
Professional Azure SQL Database Administration

Professional Azure SQL Database Administration

5 (2)
By: Ahmad Osama

Overview of this book

As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It’s important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. It is a complete guide for database administrators, and ideal for those who are planning to migrate from on premise SQL Server database to an Azure SQL Server database.
Table of Contents (11 chapters)
close
close
Free Chapter
1
1. Microsoft Azure SQL Database Primer
4
4. Restoring an Azure SQL Database
10
Index

High Availability


High availability refers to providing business continuity when the physical server hosting the Azure SQL Database fails.

As discussed in Chapter 1, Microsoft Azure SQL Database Primer, an Azure SQL Database is hosted on three servers – one primary and two secondary servers:

Figure 8.1: Azure SQL Database is Hosted on Three Servers

The toyfactory database consists of three servers; one primary and at least two secondary servers. The Azure SQL Server is just a logical server name used for connection. When an application sends a connection request, the gateway finds out the current primary server and routes the request to the primary server.

The primary and secondary servers are within the same datacentre and together form a quorum-set.

All read and writes are made to the primary server. Azure SQL Database uses a quorum-based commit method that makes sure that the data is hardened at the primary server and replicated to at least one secondary server before the transaction...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY