Distributed Partitioned Views are real the only way 2 load balance in MS SQL
but u will need MS SQL 2000 Enterprise Edition.
>From Rif Kiamil
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 12:32
To: CF-Talk
Subject: RE: Another clustering question (MS SQL 7.0).
Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB
and 2 SQL servers. One of the SQL servers is live and the other is passive,
both sharing a disk array containing the databases. If server 1 fails then
server 2 takes over.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Alexandr Timchur [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 12:29
To: CF-Talk
Subject: Another clustering question (MS SQL 7.0).
Dear subscribers,
talk me please about clustering software you use for cluster MS SQL
Server 7.0 (or 2000).
I would like to solve two problems - the first: solution must provide
fault tolerance, the second: load balancing very desirable for me.
I tried MS Cluster Service and Legato Cluster Server - those products
are good for solving first problem, but I can't find any product that
can provide load balancing - it possible in common case for MS SQL
Server?
Thank you,
Alexandr Timchur.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
