DBInsight's Blog

Archive for Availability Group

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) →

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) →