You set up both SQL servers. Install SQL and what not. Once those servers are set, you then install CoStandby Server (now named AutoStart)
In Legato, you create a virtual IP address for the two servers to use. This IP address will be the IP address you use in the data source in the CF administration. (assuming you us TCP/IP, in which you must for Legato to work) This IP address will be different from the physical IP address of the machines. When the primary database server crashes, Legato brings the secondary server active using the virtual IP address. Legato manages the active/passive setup. CF will never know if one goes down or the other. It is transparent to CF. I have a 3 second delay in my Legato setup. If my primary server crashes, I give Legato a 3 second wait until it makes the secondary server active. This is so a hiccup in the network does not cause the secondary server to become active unnecessary. For the amount of database transactions we do, this is acceptable to us. I like Legato over Microsoft because with Microsoft, the two servers share the mirrored drive. In Legato, the servers have a separate hard drive that Legato mirrors. http://legato.com/products/autostart_se/index.htm Jacob -----Original Message----- From: Tony [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 8:41 AM To: CF-Talk Subject: Re: CFMX and Sql Server 2005 (mirrored instances) VIP address? is that a legato thing? so legato sits in front and manages the ACTIVE/PASSIVE setup, and cfmx looks to legato for "WHERE TO LOOK" or something like that? tw On 12/16/05, Jacob <[EMAIL PROTECTED]> wrote: > We have two mirrored SQL 2000 servers (soon to be 2005). We use Legato > CoStandby Server in an active/passive mode. You create a VIP address and > use that in your data source setup. > > We have been using it for about 6 years now and have had no problems. > > Not sure if this helps you for your situation, but just another idea. > > Jacob > > -----Original Message----- > From: Tony [mailto:[EMAIL PROTECTED] > Sent: Friday, December 16, 2005 8:07 AM > To: CF-Talk > Subject: CFMX and Sql Server 2005 (mirrored instances) > > hola peeps... > > ok, we are thinking of bringing a new SQL Server 2005 into our > application systems and one of the things we are thinking about > using is two mirrored servers... both are going to be the same data > and structure however they will not share an ip address, or name. > > ...NET can handle this in its new connection string setting "Failover" > and im just wondering how/if ColdFusion MX 7 will handle this, or not > handle this. > > Anyone doing this yet? > > Thanks! > tony > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227178 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54