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