DBInsight's Blog

Archive for High Availability

Licensing Active/Passive SQL Server Configurations in the Cloud

Considering a SQL Server active/passive configuration in the Cloud? If so, be prepared to fork out more in SQL Server licensing if deploying to shared third party server providers like Azure and AWS. First of all you will need software assurance to be able to assign a BYO SQL Server license to a VM running […]

Continue Reading →

Posted in: Availability Group, AWS, Azure, Cloud, High Availability

Leave a Comment (0) →

SQL Server Failover between AWS and Azure using SQL 2014 Standard Edition

In Part 1 of this series I described how to create a three node, multi-site SQL Server 2014 cluster across two AWS servers and an Azure VM using SIOS DataKeeper Cluster Edition to mirror the clustered data disk. On the positive side the article presented a neat and robust HA/DR solution for AWS cloud implementations, […]

Continue Reading →

Posted in: AWS, Azure, Cloud, Cluster, High Availability

Leave a Comment (0) →

SQL Server Failover between AWS and Azure – Part 1

We have all heard the story about the online business whose AWS account got hacked and had all of its Cloud inventory destroyed, then there’s the occasional scenario where a Cloud provider is totally disabled by a “core” infrastructure fault. What if you could seamlessly failover between Cloud providers and eliminate the “all eggs in […]

Continue Reading →

Posted in: AWS, Azure, Cloud, Cluster, High Availability

Leave a Comment (4) →

VMware Snapshot Kills Availability Group Cluster

Recently I was requested to investigate the Cluster failures underlying a SQL Server 2012 Always On Availability Group. The topology was a two node Windows 2012 cluster with a file share tie breaker as part of the Majority Node and File share Quorum model. The cluster servers were VMware 5.1 Guests and SQL Server 2012 […]

Continue Reading →

Posted in: Availability Group, Cluster, High Availability, VMware

Leave a Comment (2) →

Which Windows Version/Edition to Use for Availability Groups

In this SQL Server Pro article Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups Michael Campbell makes a case on why Windows 2012 Standard edition provides the best bang for buck in supporting your AlwaysOn Availability Group implementation. Interestingly he also highlights some reasons why he thinks the older Windows version, Windows […]

Continue Reading →

Posted in: Availability Group, High Availability

Leave a Comment (0) →

Migrating Database Mirroring to an Availability Group – No 2

Flowing on from my previous article Migrating Database Mirroring to an Availability Group I thought it might be worth posting the high level steps that worked for me in converting a SQL Server 2008 R2/Windows 2008 R2 Enterprise Database Mirroring implementation into a two node Availability Group environment with the second node in a remote […]

Continue Reading →

Posted in: Availability Group, High Availability

Leave a Comment (0) →

Migrating Database Mirroring to an Availability Group

Recently I had to develop a migration plan to move a two server SQL Server 2008 R2 database mirroring environment to a two server SQL Server 2012 Availability Group (AG). The challenges were to minimise down time where possible, avoid transferring 40+ GB of database backups to the second server in the disaster recovery site […]

Continue Reading →

Posted in: Availability Group, High Availability

Leave a Comment (0) →

AWS EC2 SQL Server Clustering

Ok so you can’t actually setup a failover cluster in the traditional sense on Amazon Web Services (AWS) EC2 instances (virtual machines). Essentially AWS does not provide a disk storage option that allows you to provision cluster aware, shareable disk devices. However, all is not lost, SQL Server Magazine’s Denny Cherry article (here) highlights a […]

Continue Reading →

Posted in: AWS, Cloud, High Availability

Leave a Comment (0) →