Yes this is possible , the swap over can happen at odbc level so it's
transparent to your apps / code. However this does require SQL server
Enterprise Edition running on NT enterprise Edition or the win2000 equiv.
Check out the lists @ http://www.swynk.com/
or look for a white paper on SQL server and clustering at the MS site.
Justin MacCarthy
>-----Original Message-----
>From: Paul Johnston [mailto:[EMAIL PROTECTED]]
>Sent: Friday, December 15, 2000 11:49 AM
>To: CF-Talk
>Subject: URGENT: Not OT: SQL Server Problems...
>
>
>Guys,
>
>We have a SQL Server 7 implementation with three CF servers using it as a
>database server.
>
>The problem is that it's falling over regularly (and the technical guys
>can't figure it out).
>
>That's not the problem though. We are now setting up a second SQL Server 7
>for use as a failover. It will replicate all of the data. My boss wants to
>know if it is possible for CF to use one or other of the database servers
>depending on what is up!
>
>So the idea is:
>
>For each query - check which server is up and choose one to use
>(assuming we
>can replicate all data)
>
>This doesn't make very much sense to me (it's not my idea, I just got asked
>to ask the list) as I would do it differently anyway!
>
>So situation (again)
>
>2 SQL servers
> Q: can we replicate the data so they effectively are the same?
>2 CF Server
> Q: without having to change EVERY <cfquery> can we make
>something that will
>use one or other to retrieve data depending on which one is up.
>
>Is this possible?
>
>Paul
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
