Monthly Archives: October 2018

SQL Server – Configure Backup on Availability Replicas

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

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