0

We have two SQL Server DB Servers and Shared disk in production site and 1 DB in DR Site.

  • Production site has Quorum Disk on Shared Storage.
  • Production site DB servers can access this share storage, but DR site SQL DB Server can't access it.

If Production site SQL DB Servers are down, will Windows Server Failover Cluster be Online or Offline?

Does DR Site SQL Server need Quorum disk?

1

If Production site SQL DB Servers are down, will Windows Server Failover Cluster be Online or Offline ?

If you have a setup that relies on a quorum disc, this must be available - ergo offline. This is a non recommended setup. Whoever set it up did not bother to validate it makes sense.

Geographically dispersed clusters are a proven technology (start at https://technet.microsoft.com/en-us/library/cc757840(v=ws.10).aspx) but their setup was seriously bothered here.

"The quorum data must be synchronously replicated between the sites. To ensure that the Server cluster guarantees of consistency are met, the cluster database must be kept consistent across all nodes. If the quorum disk is replicated across the sites, it MUST be replicated synchronously."

Simple like that.

If i were you, I would start retiring the error prone outdated approach and work towards AOAG with a read only replica offsite.

https://www.simple-talk.com/sql/database-administration/sql-server-2012-alwayson/

This eliminates the shared storage even locally (which IS a problem - shared storage means a dying server crashing the database structure takes down the cluster). The DR scenario is a complicated one, though. You likely end up having to have the quorum disc replicated.

1
  • Thank you Sir, your suggestion really helps and will work on them. – SQLBoy May 6 '16 at 8:28

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.