Showing all posts tagged: 'AlwaysOn'

A 4-post collection

Configuring SQL Server Always On Availability Groups in Azure - Part 3

This is the last of the 3 part blog series where I will explain how to setup Always On using primarily PowerShell and a little bit of GUI. In this section we discuss how to setup and test the Always On SQL Server functionality Prerequisites### You have already completed Part 1 and Part 2 of the series. Part 3 - Prepare the cluster nodes for Always On### You can simply copy paste the code below and execute it step by step in order to implement Part 3 ########################################################## #Step: 1 #Description: Start an Azure PowerShell session # Or start an elevated PowerShell …[read more]

Configuring SQL Server Always On Availability Groups in Azure - Part 2

This is part 2 of a 3 part blog where I will explain how to setup Always On using primarily PowerShell and a little bit of GUI. In this section we discuss how to install and configure the Windows Server Failover Cluster in Azure to support the Always On functionality Prerequisites You have already completed Part 1 of the setup as described here. Part 2 – WSFC configuration You can simply copy paste the code below and execute it step by step in order to implement Part 2 ## PREPARE THE ENVIRONMENT FOR THE CLUSTER DEPLOYMENT ## ########################################################## #Step: 1 #Description: Start an Azure …[read more]

SQL Server Always On Availability Groups – Issue with preferred replica for log backups

Over the last couple of days I’ve been trying to customize Ola Hallegren’s script in order to perform backups on an Always On Availability Group running on Azure (blog to follow soon)[1]. I managed to get everything working apart from the Log Backups and the culprit was fairly easy to find. In Ola’s DatabaseBackup stored proc, there is a section of code that checks whether the specified backup type (full, diff, log) can run on the current server as per below: IF @Version >= 11 AND @Cluster IS NOT NULL BEGIN SELECT @CurrentAvailabilityGroup = availability_groups.name, …[read more]

Configuring SQL Server Always On Availability Groups in Azure - Part 1

One of the coolest features in Azure is the fact that you can create Always On Availability Groups and configure a Listeners in order to provide high availability and redundancy to your back-end SQL Server solution. If you want to know more about AlwaysOn and what it can do for you, you can go here. Up until recently, Always On was a bit “hacky” on Azure as we had to use workarounds, especially for the Listener part, which is one of the most important feature as far as applications are concerned. However, the latest patches and updates to Windows Server …[read more]