Windows 2003 Cluster and SQL 2005 Server Clustering

Networking/Security Forums -> Databases

Author: gnjain PostPosted: Thu Jan 03, 2008 8:03 pm    Post subject: Windows 2003 Cluster and SQL 2005 Server Clustering
    ----
Dear All,

I have to create Active/Active Clustering for SQL 2005.

I have install Windows Clustering on both the Server.
If Node1 goes down Second Node2 is running up.

OS is Windows 2003 Server Enterprise Edition
SQL 2005 Server Enterprise Edition

But now how to install SQL clustering in Active/Active mode.
If I am missing some thing please let me know.

Please tell me or give me step by step for installing and configuring SQL 2005 Clustering in Active/Active mode.

it would be great if i get some doc where it has shown in practically how to do it Active/Active SQL 2005 Clustering.

Author: virtualinfo PostPosted: Wed Sep 03, 2008 5:15 am    Post subject:
    ----
Hi Girish Jain,

I would to recommend you with these links with tools or utilities that may serve to work with your request. I think this will give you some important details in regards to how to install SQL clustering in Active/Active mode. You can review first the OS info about Microsoft Windows Cluster Services For Windows 2003 & Windows 2008.
---
http://www.itcomparison.com/blg/welcome-aboard/microsoft-windows-cluster-services-for-windows-2003-windows-2008.html
---
Keepin' you in touch.

Smile

Author: EricaRowletLocation: US PostPosted: Thu Sep 04, 2008 9:15 am    Post subject:
    ----
Here is article which gives step-by-steps instructions for installing a SQL Server 2005 instance in a cluster. The assumption for this example is that you will be installing this instance in a 2-node active/passive cluster. Even if you will be installing a 2-node active/active or a multi-node cluster, the steps in this section are virtually the same. The only real difference is that you will have to run SQL Server 2005 setup for every instance you want to install on the cluster, and you will have to specify a different logical drive on the shared array. Hope it may be of any use to you.

http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx



Networking/Security Forums -> Databases


output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group