Re: Active Passive to Active Active
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 12/15/04
- Next message: GvB: "log shipping"
- Previous message: Aju: "Re: Active Passive to Active Active"
- In reply to: Aju: "Re: Active Passive to Active Active"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Dec 2004 09:28:24 -0500
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 > 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 > > 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 , > > > > Can we convert the Active passive cluster to Active Active mode . > > > > Please advise . > > > > > > > > Thanks > > > > ARR > > > > > > > > > > > > > > > > > > > > > > > >
- Next message: GvB: "log shipping"
- Previous message: Aju: "Re: Active Passive to Active Active"
- In reply to: Aju: "Re: Active Passive to Active Active"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
