Hi,
We want to install 2 SQL server in cluster with a bay of disk. We have some
databases running with SQL 7.0
My question is what is the best choice active/active or active/passive?
Thanks,
J-F Lefebvre
by J-F Lefebvr » Wed, 30 Aug 2000 04:00:00
We want to install 2 SQL server in cluster with a bay of disk. We have some
databases running with SQL 7.0
My question is what is the best choice active/active or active/passive?
Thanks,
J-F Lefebvre
by Brad » Wed, 30 Aug 2000 04:00:00
Active-active is better if you can do it in your scenario.Quote:> Hi,
> We want to install 2 SQL server in cluster with a bay of disk. We have some
> databases running with SQL 7.0
> My question is what is the best choice active/active or active/passive?
by Greg D. Moor » Thu, 31 Aug 2000 09:47:29
> > Hi,
> > We want to install 2 SQL server in cluster with a bay of disk. We have some
> > databases running with SQL 7.0
> > My question is what is the best choice active/active or active/passive?
> Active-active is better if you can do it in your scenario.
I don't think there is enough information given to say for sure. (And
granted, you do qualify your answer).
by Brad » Thu, 31 Aug 2000 04:00:00
> > > Hi,
> > > We want to install 2 SQL server in cluster with a bay of disk. We have some
> > > databases running with SQL 7.0
> > > My question is what is the best choice active/active or active/passive?
> > Active-active is better if you can do it in your scenario.
> Why would you say that?
> I don't think there is enough information given to say for sure. (And
> granted, you do qualify your answer).
1. Active/Active vs Active/Passive Documentation
How come there's loads of documentation about Active/Passive clusters and
hardly anything for Active/Active?
I've posted here before but didn't really get any great responses - I'm
hoping a repost may help things.
If we are in Active/Active do we need an instance of MSDTC per instance of
SQL?
The online documentation for SQL 2000 mentions the MSDTC Proxy and provides
no details, and I can find no reference to this on the MS site.
2. DB.Execute " DROP TABLE " & tblName , dbFailOnError
3. Active/Active vs Active/Passive
5. Active/Active or Active/Passive?
6. Comparison chart of JDBC-accessible RDBMSes?
7. Active/Active vs Active/Passive???
8. Converting Active/Active to Active/Passive on SQL Server 7.0
9. active/active or active/passive??
10. Clustring active/active and active/passive
11. active/active or active/passive?
12. Cost associated with going from SQL active/passive to Active/active