I have this booked marked just for your reason... http://www.bealearts.co.uk/blog/2007/06/17/coldfusion-and-sql-2005-mirroring /
But, I may go with Clustering instead. -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, May 15, 2008 9:14 AM To: CF-Talk Subject: CF8 - SQL 2K5 and Mirroring Good morning all, I am finishing the set up for my mirroring server and the witness server so I can have automatic failover on my SQL boxes. Once I get this all set up, is there anything on my CF Admin side I have to do to ensure that this works properly? I googled the hell out of this and can't find a clear answer. My concern is that on the CF Admin I specify the primary server for my DSN. If the primary server fails for whatever reason, how will CF know that the witness server switched everything to the mirror? Or does it impersonate it? Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
