MS SQL Server Clustering - Clustering

Author

Clustering - Active / Active nodes

Alistair Wong

2005-04-18, 3:23 am

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

Rodney R. Fournier [MVP]

2005-04-18, 3:23 am

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@discussions.microsoft.com> wrote in message
news:DA956B40-736A-4A10-A11D- BDAAC07FDACF@microso
ft.com...
>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

Sponsored Links