Active Passive to Active Active

Hi ,
Can we convert the Active passive cluster to Active Active mode .
Please advise .
Thanks
ARR
Its not really a conversion per se. You can install up to 16 instances per
SQL cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23Q2Leyd4EHA.2404@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> Can we convert the Active passive cluster to Active Active mode .
> Please advise .
> Thanks
> ARR
>
>
|||Hi
With SQL Server 2000, Active/Active or Active/Passive is just a term used to
describe the server, and not a setup limitation.. By adding the necessary
recourses, such as file disk groups, you can turn an A/P into an A/A.
If you currently have a instance with 3 drives (E, F, and G), to create
another instance, you can not use those drives, so you need to get more
volumes on your SAN for H, I, J etc.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:#tingLe4EHA.4004@.tk2msftngp13.phx.gbl...
> Its not really a conversion per se. You can install up to 16 instances per
> SQL cluster.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Aju" <ajuonline@.yahoo.com> wrote in message
> news:%23Q2Leyd4EHA.2404@.TK2MSFTNGP14.phx.gbl...
>
|||Hi ,
Thanks for the reply .
Any other steps tobe done while installing instance on other volumes or if
we install other instance whether it will run on other node by default .
My assumption is on both node two different instances will run after adding
one more instance .
Thanks
Ajay
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e0ODKEh4EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi
> With SQL Server 2000, Active/Active or Active/Passive is just a term used
to[vbcol=seagreen]
> describe the server, and not a setup limitation.. By adding the necessary
> recourses, such as file disk groups, you can turn an A/P into an A/A.
> If you currently have a instance with 3 drives (E, F, and G), to create
> another instance, you can not use those drives, so you need to get more
> volumes on your SAN for H, I, J etc.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:#tingLe4EHA.4004@.tk2msftngp13.phx.gbl...
per
>
|||Except for the actual installation process, all cluster nodes in SQL 2000
are equivalent. During the installation, you run the install app from the
node that currently hosts the disk resource you intend to base the SQL
instance on. You can set the allowed and preferred hosts for each SQL
resource group independently after installation. Be sure to test running
with both instances on one node because that is what will happen during a
failure.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Aju" <ajuonline@.yahoo.com> wrote in message
news:uSwNvnq4EHA.2196@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> Thanks for the reply .
> Any other steps tobe done while installing instance on other volumes or if
> we install other instance whether it will run on other node by default .
> My assumption is on both node two different instances will run after
adding[vbcol=seagreen]
> one more instance .
> Thanks
> Ajay
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:e0ODKEh4EHA.2624@.TK2MSFTNGP11.phx.gbl...
used[vbcol=seagreen]
> to
necessary
> per
>
sql