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. Now my question is say you primary server fails and goes off line. The mirrored server kicks in. How do you get your CF server to look for the database on the mirrored server? Obviously the two servers cannot have the same IP or name since they are on the same network. Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4