I do not have any experience with MS SQL. I'm a hardware engineer. I focus
mainly on the servers hardware and connectivity.

I was wondering, is it possible to cluster 2 (or more) nodes running all
nodes on active / active as a single MS SQL database system? The servers are
connecting to a common shared storage system.

Is this possible? This is more of a scale out strategy.

Thanks

I am sorry to tell you that is not. A database will only run on one machine
at a time. Clustering will not help you with this problem.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog

"Alistair Wong" <Alistair Wong (AT) discussions (DOT) microsoft.com> wrote