Cross Datacenter Failover with SQL 2005 and MOSS 2007 1 of 2
So there is alot of information on the internet and the recent webcasts of disaster recovery with SharePoint, however rarely do you see Distser recovery BETWEEN datacenters. Understandably, few implementations of SharePoint for a user base less than 5000 users would require cross datacenter failover, however, consider hosted internet provider solutions, which are becoming more ubiquitous, or consider large corporations (like where I work) that have 31,000 employees and need highly available large farms.
We are planning for disaster recovery across datacenters using database mirroring using a witness server to synchronize data between the primary tier 1 data center in Canada and the UAT environment in another datacenter in the United States. The target, redundent SQL databases in UAT are not used by the UAT instance. In addition, there is a parralel instance of SharePoint that EXACTLY matches the production environment – NOTE that this is not used for UAT, but sits on the same hardware.
From a Release management perspective, all changes propigated from UAT to Production, MUST be released to the Failover instance on the UAT hardware as well.
I will write more on this, in terms of configuring the database mirroring, and release management in the coming weeks.

This entry was posted
on Friday, September 22nd, 2006 at 3:46 pm and is filed under Uncategorized.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Cross Datacenter Failover with SQL 2005 and MOSS 2007 1 of 2
So there is alot of information on the internet and the recent webcasts of disaster recovery with SharePoint, however rarely do you see Distser recovery BETWEEN datacenters. Understandably, few implementations of SharePoint for a user base less than 5000 users would require cross datacenter failover, however, consider hosted internet provider solutions, which are becoming more ubiquitous, or consider large corporations (like where I work) that have 31,000 employees and need highly available large farms.
We are planning for disaster recovery across datacenters using database mirroring using a witness server to synchronize data between the primary tier 1 data center in Canada and the UAT environment in another datacenter in the United States. The target, redundent SQL databases in UAT are not used by the UAT instance. In addition, there is a parralel instance of SharePoint that EXACTLY matches the production environment – NOTE that this is not used for UAT, but sits on the same hardware.
From a Release management perspective, all changes propigated from UAT to Production, MUST be released to the Failover instance on the UAT hardware as well.
I will write more on this, in terms of configuring the database mirroring, and release management in the coming weeks.

This entry was posted
on Friday, September 22nd, 2006 at 3:46 pm and is filed under Uncategorized.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.