I have the book "SQL Server 2005 Unleashed". It is saying you have three servers. You Principal Server, Witness Server and Mirror Server. The Witness server is what decides when to switch over to the Mirror Server.
What about adding some code in Application.cfm so if I get a database error to change my application.dsn variable (that all of the CFQuery tags will be using) to the backup servers DSN. So I just have both databases setup in Coldfusion one for the Principal Server and one for the Mirror Server just flip my application variable based on if the server is responding. Sounds kind of flaky. -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, November 05, 2007 3:14 PM To: CF-Talk Subject: Re: MS SQL Mirroring and CF Chad Gray wrote: > I am reading up on mirroring our MS SQL server. > > What I have read you can setup a second server with a second installation of > MS SQL. The licensing allows for this also so you don't have to buy two > copies. > > Now you can mirror from one server to the other. There are several ways to do this. Which manual are you reading? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
