Tag Archives: availability groups

Upgrading SQL Server using Availability Groups – Checklist

Posted on October 17, 2019 by thomasrushton

This is a checklist put together and followed for an upgrade of a pair of physical SQL Server 2012 servers which hosted a single availability group of several terabytes of data with minimal downtime. The availability group was configured with … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 3 Comments

Availability Groups, Busy Databases, and Badly-Timed Reboots

Posted on August 27, 2019 by thomasrushton

A server’s availability group was mostly healthy, but for a couple of databases. There was nothing apparently wrong, but they weren’t synchronised, and we were beginning to see transactions failing to complete as they couldn’t be written on the secondary. … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

SQL Server Availability Groups and SQL Server Reporting Services – A Brief Rant Triggered By Someone Failing Something Over Without Understanding The Full Implications, Or, Pay Attention To Your DBA Because He Knows This Stuff And That’s What You Pay Him For

Posted on July 2, 2018 by thomasrushton

Is the headline longer than the body? Not now I’ve included the fix for this situation as well as the initial rant. Maybe next time. Yes, you may have an availability group – well done – and you may have … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

Skype for Business – SQL Server Frustrations

Posted on August 1, 2017 by thomasrushton

Scenario The environment is new and secure. Assumptions: You are a DBA who knows how to build WSFCs and AGs. If you need help with that, then you’re in the wrong place for this post. The Windows 2016 / SQL … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment