I started of setting up an SQL Availablity Group but quickly ran into problems caused by windows firewall. After getting the environment setup, I performed a failover test, verified everything was working okay. After failing back over to the original primary, I added a database to the availability group via
Recently, I was working with a gentleman in our IT department and we were discussing adding redundancy to a couple of SQL Servers that were used for web apps. Turns out, VMware’s disk consolidation can, and will, take a server offline. That tends to make customers unhappy, and rightly so.