Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 12:59:11
|
| John Neylon writes "1. Have read all the background information on this topic available on this site - excellent. I feel prepared!2. I have to setup a Sql Server 2000 cluster in an Active/Active environment(as described by sys admin team).3. Question - There are 2 nodes (A,B) , 1 user database (PROD). The cluster has been setup. They call it Active/Active yet surely all I have to do is install Sql Server 2000 on Node A ..this install detects the install as a cluster etc...installs the binaries etc to the local directories on both node A and B. When I copy database PROD to Node A placing the datafiles in the 'Sql Server VirtualName' logical drives e.g. datafile drive T:, transaction logfiles drive S: the database has been installed in a clustered environment. ?4. I am puzzzled as to the description of Active/Active for this enviormnent when as far as I can see , for one database the above solution provides the clustered high avilability but is what i would describe as Active /Passive5. Can you help me with my visualisation of an Active/Active versus Active/Passive deployment. Are these terms more to do with Cluster terminology as opposed to the Sql Server deployment terminology ?regardsJohnOS= windows 2000 Adv Server, Sql Server 2000,Db is Sql 7.0 but will be upgraded afetr copying to Sql Server 2000 on the cluster" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-06-17 : 13:20:20
|
| Actually with SQL2K A/P and A/A are no longer valid terms, however they are still widely used.What A/A is, is you will install a named instanse on the second node. If failover occurs, you would be running 2 instances on 1` machine.In 7.0 this was known as A/A, with 2K it is just a named instance.What you describe is A/P.HTH-Chad |
 |
|
|
|
|
|
Clustering - Architecture Sql Server 2000