For SQL server, we use Legato Co-StandBy Server. Ours runs in Active/Passive setup. You do not need SQL Enterprise or Windows Enterprise / Advanced addition to cluster with CSBS.
http://www.legato.com You need the same type of set up (hard drive, RAM, and CPUs for it to work correctly. For web servers, we have load balancers to take care of redundancy. -----Original Message----- From: Dustin Snell [Network Automation] [mailto:[EMAIL PROTECTED] Sent: Monday, February 14, 2005 10:57 AM To: CF-Talk Subject: OT: SQL Server mirroring Sorry this is kind of OT but it does have to do with our ColdFusion driven website. We currently have no redundancy in our web server environment and would like to change this. This would mean some kind of mirror/cluster would need to be set up for our web server and for our SQL server. I know there is clustercats for ColdFusion but we want to do the database server first. Everything I am reading says you need at least *three* machines to do a simple mirror with SQL Server, is this true?? We would like to have two machines, machine A and Machine B. Machine B stays in synch with A and only goes live if Machine A is out of service. Why would this need and more than two machines? Anyone know of a way to accomplish what we are looking for? Any advise about server mirroring, and/or clustering would be appreciated. Thanks! -Dustin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:194577 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