Currently Browsing: Clustering

Using PowerShell to Move Cluster Resources to Preferred Node on Windows Server 2008 and above

Introduction In an earlier post we covered Using PowerShell to Failover Cluster Resources for Patching, to expand on the script we are adding a third option for use on active / active clusters to move the Cluster Resources to their preferred node if it is defined. We will cover creating the move by itself and also incorporating it in the script covered in the earlier post. About the Script The purpose of... read more

How To Fix Parameter is Incorrect Error Message When Adding Disk to Windows Cluster

Introduction So there you are adding a new drive to a folder on a mounted drive on a Microsoft Windows Server 2008 R2 / 2012 R2 Clustered SQL server and during the format and assigning of the disk to the folder of the mount drive a big error pops up stating Parameter is Incorrect. And you are now dead in the water, or at least you think. We’ll all is not lost, there is a solution! You will encounter... read more

How To Install Failover Clustering with PowerShell

Introduction In this post we will cover some more automation with PowerShell and in automating installing Failover Cluster features with PowerShell on Windows 2008 R2 and Windows Server 2012 R2. We will cover the commands available to install the features needed that can be run individually and also a simple script to install the features and log the results. So what are the features available to install... read more

Using PowerShell to Failover Cluster Resources for Patching

Introduction So you are having to patch cluster nodes and would like a way to automate the failover of the resources and log what when it was done and who did the work. In this post we will cover a simple PowerShell script that will drain and pull resources in a 2 node active / passive cluster. About the Script The purpose of the PowerShell script is to allow two operations to occur, they are to drain all... read more