Wednesday, February 26, 2020

Set RegisterAllProvidersIP value for WFC and Quorum Take Online/Offline

I am using powershell to get and set RegisterAllProvidersIP cluster parameter.

#Get Network Name
Get-ClusterResource  -Cluster "SQLDRPOCACN"

# Get Cluster parameter
Get-ClusterResource "SQLDRPOCAG_SQLDRPOCALS"  -Cluster "SQLDRPOCACN" | Get-ClusterParameter

# Set ClusterParameter RegisterAllProvidersIP
Get-ClusterResource “SQLDRPOCAG_SQLDRPOCALS” | Set-ClusterParameter RegisterAllProvidersIP 0


The powershell script will take Quorum take online and offline.

Get-ClusterResource  -Cluster "SQLDRPOCACN"

#Bring up File Share Witness online
Get-ClusterResource "File Share Witness"  -Cluster "SQLDRPOCACN" | Start-ClusterResource -Name "File Share Witness"
#Take File Share Witness offline
Get-ClusterResource "File Share Witness"  -Cluster "SQLDRPOCACN" | Stop-ClusterResource -Name "File Share Witness"


Thank you for reading my blog.

How to add a Database to AlwaysOn Availability Group with four different options

To add a database to an existing AlwaysOn availability group, MS has given us four options to choose from Automatic seeding Full database an...