SQL SERVER – Steps to Migrate Cluster Storage from Old Disks to Newly Attached Disks

One of my clients consulted me for the best and easy method for migrating the Cluster Storage from old to newly attached disks. They wanted to move/reconfigure disks mapped to SQL Server, MSDTC, Quorum.

At present, they were using SQL Server 2014 as a mission-critical database server in a cluster environment. Storage being used was IBM DS 8300. They want to migrate the database from current storage i.e. IBM DS 8300 to new storage IBM DS 8870.

Read More

QL SERVER – Unable to Create Listener: Msg 41009 – The Windows Server Failover Clustering (WSFC) Resource Control API Returned Error Code 5057

One of my clients contacted me for quick On-Demand consulting. They were working under close deadlines and delivering the solution on time was critical for their success. They contacted me and explained that they were having trouble creating a listener for their two nodes AlwaysOn Availability Group. The error message which they received from T-SQL is below. Let us learn how we can fix error related to Windows Server Failover Clustering.

Read More

SQL SERVER – Error 1324. The folder path ‘Program Files’ contains an invalid character.

Some error messages are so interesting that it takes a lot of time to get the right solution. One of the errors which I faced during SQL Cluster installation is so common that my search was showing various solutions which were not applicable to me. After spending a lot of time, I was able to find the real cause. In this blog, we would learn about SQL Cluster installation error “The folder path ‘Program Files’ contains an invalid character.”

Read More

SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node

While working with many clients, I learned that “there could be many problems leading to same symptoms”. In this blog, we would learn about a reason which can cause empty startup parameter in SQL Cluster.

Long ago, I worked with a client and found that registry permission can cause empty startup parameter in SQL Server Configuration Manager.

Read More

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 – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check

This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL. 

While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check.” If we check Detail.txt file in setup logs, we will find below.

Read More
Exit mobile version