March 20, 2012 at 8:58 am
We are in the process of setting up two new datacenters. One will be the primary and the other backup for high availability. With this type of design, what method is anyone employing for high availability (log shipping etc).
March 20, 2012 at 11:05 am
Its not possible to answer this question with the information give?
What thought have you put into it and do you have any idea what you need to achieve to provide your business with a continuity site? Have the business provided you with their maximum requirements for downtime?
March 20, 2012 at 12:07 pm
Business requirement would be no downtime. With an automatic failover from primary to secondary. We would be able to get away with one hour from primar failure to secondary uptime.
I know we can use log shipping, however, that too require a restore of the database on the secondary SQL server. Is there an automatic process that we can implement, that would give us automatic failover?
March 20, 2012 at 12:38 pm
Mirroring or clustering would be your best option for minimal downtime. Both should allow for less than 5 minutes of downtime provided you're prepared.
Mirroring has an administrative overhead of ensuring users, jobs etc are manually applied (at least until 2012 is in place). If you need this to be automatic a witness would work but would need to be correctly configured for latency. In .net applications, sql connections can be configured with a secondary server which the application will automatically use.
Geoclustering would also work assuming your network infrastructure is up to scratch and you can implements some kind of disk volume mirroring (SAN mirroring is most common).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply