Hello Everyone,
I'm working on a project to set up database mirroring for a CRM 4.0 deployment with SQL 2008 dbs. We have a production environment and a mirrored environment, and they both have an APP server and a DB server. We're setting up high-safety mode mirroring, so the SQL server in the production environment is the principal server, and the SQL server in the mirrored environment is the mirrored server, and there is a witness server.
As this is a first for me, I wanted to confirm a few things about my understanding of what I've read in this article: http://support.microsoft.com/kb/952278
1. The changes in steps 2 and 3 (putting the mirror server into the connection strings in the registry and in the MSCRM_CONFIG db) should enable automatic failover, correct? When the production SQL server goes down, the web server should automatically begin using the mirrored server as its db server?
2. My initial evaluation of their approach to having a production and a back-up APPLICATION (web) server: there will not be any failover for the web servers - these should not be set up in 2 separate environments where one will be expected to pick up if the other goes down, similar to the SQL servers. Instead, they should be configured as 2 active app servers, and in the instance of one going down, the other will continue to operate. Correct?
If someone who's done this can confirm or deny these 2 assumptions, I would greatly appreciate it.
Best Regards,
Web: http://invoc.net Blog: http://invoc.net/CRM_BPOS_Blog
