A Cluster Network Name would not come online and showed NETBIOS status ‘The system cannot find the file specified’. Which log to check and how we fixed it.
SQL SERVER – Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working
A client added a new node to the Windows Cluster and their AlwaysOn databases stopped synchronizing. The culprit was a wizard default, and here is the fix.
SQL SERVER – Fix: The Cluster Resource Could not be Deleted Since it is a Core Resource
After changing a file share witness, a client could not delete the old one: the cluster resource could not be deleted since it is a core resource. The fix.
SQL SERVER – GetRegKeyAccessMask : Could Not Get Registry Access Mask For Registry Key – SQL Server Cluster
In a two-node SQL Server Cluster, SQL would not come online on one node and wrote no ERRORLOG. The cluster log showed GetRegKeyAccessMask. Here is the fix.
SQL SERVER – Installation Error – The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive.
Installing SQL Server 2008 SP4 on a cluster failed with: The wrong diskette is in the drive. Here is what the setup logs showed and how we fixed it.
SQL SERVER – Understanding FAILOVERCLUSTERROLLOWNERSHIP with SQL Server Cluster Rolling Upgrade
I started to hunt in the blog and saw there were a number of posts around (FAILOVERCLUSTERROLLOWNERSHIP) the cluster that caught my eyes:
SQL SERVER – Q&A: SQL Clustering Virtual Server Name and Instance Name
Basic SQL Clustering questions from a team new to cluster installs, like whether a new clustered instance needs a new virtual server name, answered one by one.