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?
Showing posts with label nodes. Show all posts
Showing posts with label nodes. Show all posts
Wednesday, March 28, 2012
Wednesday, March 21, 2012
New SQL Instance in an existing SQL Server 2000 Clustered Environm
Can I install a new SQL instance in one of the nodes in a clustered
environment?Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:
> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>
environment?Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:
> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>
New SQL Instance in an existing SQL Server 2000 Clustered Environm
Can I install a new SQL instance in one of the nodes in a clustered
environment?
Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:
> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>
environment?
Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:
> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>
New SQL Instance in an existing SQL Server 2000 Clustered Environm
Can I install a new SQL instance in one of the nodes in a clustered
environment?Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:
> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>sql
environment?Hi
Yopu can, but if you need it independent of other instances, you have to
create a new Virtual SQL Server with it's own SAN LUNS etc.
Regards
Mike
"Randy Gadingan" wrote:
> Can I install a new SQL instance in one of the nodes in a clustered
> environment?
>sql
Subscribe to:
Posts (Atom)