SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations

During one of my consultancy related to Always On availability group deployment, I faced an interesting issue. They wanted to install two standalone SQL Server instances on both nodes of the Windows Server 2008 R2 cluster for a specific reason. Interestingly, they informed that this used to work fine with SQL server 2008 R2 but in SQL server 2014 is failing with an error.
I checked the summary file and found the message about install error.

Read More

SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group

As a part of my consulting job, I do work with clients who wanted to deploy AlwaysOn availability group. Sometimes there are some simple errors which are encountered, but new DBAs are not aware of such things. In this blog we would talk about one of such error.

Read More