Wednesday, March 28, 2012

New to Clustering - 2003 Server Enterprise & SQL 2000

I am new to clustering and would like to implement and active/active SQL
cluster, which would allow the functions of one of the nodes to fail over to
the other in the event of a problem.
I have two identrical servers in terms of hardware connected to a SAN and
running Windows Server 2003 Enterprise and will be using SQL 2000.
What are the steps for setting this up?
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
> to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?
1. Attend training to support your extremely expensive cluster with
extremely important databases.
2. Build your cluster
3. Install SQL on your cluster
http://support.microsoft.com/Default.aspx?kbid=243218
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||What do "you" mean by Active/Active? In a clustered configuration, you
install SQL Server to all participating nodes, but then a virtual server is
hosted by only one of them at any given time. If, however, one of the nodes
becomes unavailable, one of the other nodes can host the resources.
Active/Active on Microsoft Clustering means you have multiple cluster
resource groups (i.e., virtual servers) running at the same time with
multiple nodes all hosting different resources.
Anthony Thomas

"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?

No comments:

Post a Comment