Category Archives: High Availability

SQL Server – Configure Backup on Availability Replicas

Posted on October 26, 2018 by ConfigMgrMVP

For a recent project, I needed to create a backup maintenance task for databases in a SQL Server Always On Availability group. In three separate AO environments. Now there are several options available: Use custom backup jobs Use Ola Hallengren’s … Continue reading →

Posted in High Availability, SCCM, SQL Server | Leave a comment

Failed to create Availability Group Listener

Posted on October 17, 2018 by ConfigMgrMVP

In implementing a SQL Server Always On availability group; I know I’ve run into this issue in the past, so figured I’d document the solution. The Windows Server Failover cluster was properly created. The SQL Server Always On Availability Group … Continue reading →

Posted in Always ON, High Availability, SQL Server | Leave a comment

SCCM High Availability Role

Posted on May 22, 2018 by ConfigMgrMVP

At MMS2018, one of the more interesting items was the introduction of the new SCCM HA Role (hint: this is in 1805 TP). Now, it could be that I’m only slightly partial, given that it was one of sessions that … Continue reading →

Posted in High Availability, SCCM | 4 Comments

SQL Server – Availability Group Issue

Posted on August 5, 2016 by ConfigMgrMVP

Spent part of a day chasing down an SQL Server Always On Availability Group manual failover, failure issue. When running the failover wizard, the failure looks like this: Some of the error description: Manual failover failed. Failed to perform a … Continue reading →

Posted in High Availability, SQL Server | Leave a comment