There are many ways to setup High Availability and Disaster Recovery, most of which are focused on SQL Server Enterprise edition. However, the licensing for Enterprise edition gets costly fast. One less talked about approach to building a cost-effective HA/DR solution is building a failover cluster instance using SQL Server Standard with SIOS Datakeeper. SQL … Read more
Believe me, every heart has its secret sorrows, which the world knows not, and oftentimes we call a man cold, when he is only sad. Longfellow, Hyperion (1839) This post has been rattling around in my head for several years. Of late, though, the rattling has turned into a steady vibration. The day before I … Read more
Availability groups, Failover Clusters, Log Shipping, and more. These are tools we use to ensure that the data is highly available and disaster recoverable. This post will be the general walkthrough for how to determine what may be going wrong with your HA/DR solution, as well as some general tips and tricks from what we … Read more
If you’ve ever tried migrating a SQL Server database from one server to another, you know it can be a white-knuckle ride from start to finish. You need to wait forever while you backup and restore, change all your connection strings to point to the new server, and forget to change the data sources for … Read more
On Tuesday, 12/13/22, we presented a webinar about HA/DR (high availability and disaster recovery). Join Team Straight Path as we discuss what HA is, what DR is, and how they are different. We talked about the ways to achieve HA and DR. We’ll talk about the things we’ve learned about HA and DR along the … Read more
It’s upgrade season. Here at Straight Path, we have more than a couple of clients in the process of upgrading their SQL Environments to a more modern version. With the support door slamming shut soon for SQL 2008 (waaaay overdue), and others on 2012 (really not in a much better position – support wise) clients … Read more
If you have SQL Server instances that are out of support, which is any version prior to SQL Server 2014, then I’m sure you have your reasons for not upgrading to a newer version. Let’s take a quick look at those reasons and then examine one reason you might not have considered. My hope is … Read more