I was recently asked about T-SQL Snapshot backups on secondary replicas, which I hadn’t looked at for many years as it’s kind of a niche item. I was definitely surprised to find little caveats here and there, thus you get this wonderful post. If you’re unfamiliar with T-SQL Snapshot backups, it’s a way to flush […]
On, Off, On, Off, On… I see this more often than I’d like to, so count this as your PSA (public safety announcement) when using VM level backup software, SQL Server, and even worse when you add in AlwayOn (FCI or AG). You might be familiar with these symptoms which may include: Unresponsive VMs Lease […]
I won’t say I told you so… I will, however, point out common AG question #8… I’m not sure why so many of these are coming up lately, but I’ve not had to troubleshoot a few, and I think it’s worth documenting this behavior. Let’s say you have Windows cluster which might have FCI’s, AG’s, […]
I had initially wrote this post with a great deal of information, but it came across as snarky and condescending which was not my original intention. Thus I’ve rewritten it in the hopes that it’s succinct and distilled down the the minimal amount of information needed to make an informed decision. This post is specifically […]
