Hi All,

We have Three Node Cluster out of which two nodes are involved in DB Cluster, third node is being used for alwayon (Only Windows Clustered).

Now the issue is both the DB Cluster nodes are down and AG databases are in "NOT SYNCHRONIZING" STATE. Since our third node for alwayon is available we want to recover databases and executed below forced failover command getting error.

- YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.
:Connect VDBTAM

ALTER AVAILABILITY GROUP [ROM] FORCE_FAILOVER_ALLOW_DATA_LOSS;

GO


GO

Error:

Connecting to VDBTAM...
Fatal scripting error. Cannot open connection specified in the SQLCMD script.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

)

--

By any chance is it possible to recover databases even primary server is down. Please suggest. Thank You

Regards,

Shiva

Resolved. FORCED QUORUM.

net start clussvc /fq and perform failover to bring DB's to synchronizing state.

Regards,

Kalyan