always on

Automatically Failover (Enable or Disable) Jobs Based on HADR Role

  • Script

If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.

2018-11-14 (first published: )

470 reads

Network Configuration of SQL Server Always On Availability Groups in Azure

  • Article

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure.

2017-10-11

2,735 reads

Blogs

Adding a Column with a Default Constraint

By

Last week a question came up about adding a column to a table, and...

Rename Azure VM OS Disk

By

In a recent post about creating Azure VMs using PowerShell, I noted a common...

How I Continuously Learn About SQL Server

By

Watch this week’s episode on YouTube. In order to stay current in a technology...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

Remove SQL Server from Failover Cluster

By SJD

Hi, I'm having a problem with a Windows Server 2008 R2 Failover Cluster with...

Existing logins get mapped to new databases

By TechotelNO

Pretty new with SQL but working my may up:-) When I create a new...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers