OS: Windows Server 2016 Standard

SQL: SQL Server 2016 Enterprise

SQL Setup: Two Nodes(Primary and Secondary Node) in PDC(Primary Data Center) having Always On Availability Group with Synchronous Mode and Automatic Fail-over. 3rd Node is in DRC(Disaster Recovery Center) with Assynchronous Mode and Manual Fail-over.

Quorom setup: Node and File Share Majority

For Failover, when PDC is down. Need to force WSFC without the quorum.

Link: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/force-a-wsfc-cluster-to-start-without-a-quorum?view=sql-server-ver15

I know there is a SQL wizard on doing the failover and failback but is there any powershell or batch script for doing it?

The reason for the scripts is to place it in SRM Recovery plan.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.