Top 7 Questions about Basic Availability Groups

AlwaysOn Basic Availability Groups provide a “basic” high availability solution for SQL Server 2016 Standard Edition. The functionality is the same as the traditional (Enterprise Edition) AlwaysOn Availability Groups but there are more limitations: The most important limitations are: Limit of two replicas (primary and secondary) No read access on secondary replica One database per…

12

How to Set Up Basic Availability Groups in SQL Server 2016

AlwaysOn Basic Availability Groups provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a deprecated feature. Basic Availability Groups are managed and created in the same way like the traditional Enterprise AlwaysOn Availability Group, but there are more limitations which are almost equally when…

31

-m Startup Parameter issues

This week I delivered a disaster recovery workshop at one of clients. One of the tasks is to startup the SQL Server in a single user mode to restore the master database for example. I ran into a weird situation that I would like to share. When you startup SQL Server in single user mode,…

3

The order of automatic failover

One of the new features that has been added in SQL Server 2016 for High Availability is the possibility to configure 3 replicas for automatic failover. In SQL Server 2014, it was only possible to configure 2 automatic failover replicas. But how is SQL Server going to decide to which replica it will failover first?…

1

Backup to Azure WITH CREDENTIAL (deprecated) or SAS Token

Since SQL Server 2012 SP1 CU2 or later and SQL Server 2014 it is possible to use the Microsoft Azure Blob storage service as a backup destination. One of the key compentents in SQL Server that you need is a credential. SQL Server backup and restore processes use this credential to authenticate to the Windows…

0

Generate workload on your Azure SQL Database

At the end of last year, we have announced the Azure SQL Database Index Advisor which recommends new indexes for your existing SQL Databases that can improve your query performance. One of the prerequisites to get index recommendations is to have database usage of course. This blog post will explain how you can generate SQL…

2