Category: High Availability

Migrating Database Mirroring to an Availability Group
Posted by Rob Risetto on January 20, 2015

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 and to perform the upgrade in line (i.e. no new equipment or VMs).

Continue Reading →

AWS EC2 SQL Server Clustering
Posted by Rob Risetto on August 28, 2014

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.

Continue Reading →