Re: HOW TO PROPERT SETUP WIN 2003 & SQLK2 IN ACTIVE/ACTIVE MODE



There is no such thing as an "Active\Active" or an "Active\Passive" SQL 2000
or SQL 2005 cluster. You can have single or multiple instance clusters.
Make sure you can move all your disk resources between nodes before
installing SQL 2000 and that they have the same drive letters on both nodes.
That may be where you are having difficulties.


--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Peter" <Vik> wrote in message news:OQFDBedoGHA.4988@xxxxxxxxxxxxxxxxxxxxxxx
Guys first of all I am lost I need some serious HELP>


What I want to do is create and Active/Active Clustering environment.
Using Windows 2003 and SQL2000

For Hard Ware I am using two DELL PowerEdge 2850 servers and a PowerVault
220.



The Windows part is done or I believe so I have both note up and running,
but I am having a hard time configuring SQL 2000. When ever I installed
SQL I'm selecting the H:\drive for the data, which is located in the
powervault, but when I reboot SQL can't find it even with the other node
being off.



Also the nodes are acting a Active/Passive not as Active/Active. What step
I am missing to make it Active/Active



I know that I'm missing a lot steps but I haven't been able to find a good
guide on how to do this.





Thank you in advance.



.



Relevant Pages

  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... Senior SQL Infrastructure Consultant ... SAN/Smart array or through a fibre channel switch. ... The SAN or Smart array will dictate what internal connection the disks ... single-instance cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL server 2005 SP2 failing on cluster
    ... We have been told for a long time that MSDTC is optional on a cluster but is all but required in the real world. ... I'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86 ... see Help and Support Center at ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster group and group 0
    ... If you take a node offline, all resource groups hosted on it will fail over. ... As for your SQL 2005 cluster, if the node being upgraded goes offline during ... SQL Virtual Server name to connect to the SQL instance. ...
    (microsoft.public.sqlserver.clustering)

Loading