Put your question to the experts

Engage with your peers in legal business services with our clever crowdsourcing engine.

Ask a question »

What method of DR do people use for their Elite Enterprise system? SQL Mirroring? Backup and restore?

Just interested to see what the common practice is in case of server problems and how people fail over to their DR server?
Asked by: Lydia Austerfield
Answer this?
One the best things you can do is move the server to a fully hosted environment with a manged backup solution which includes DR.
This depends on how quickly you want to get back up and running again in the event of a failure (we call this the RTO - the recovery time objective) and how much data you can tolerate losing (we call this the RPO - the recovery point objective). When I was the Head of IT at a large law firm we implemented a SQL Server cluster for our Elite system, which provided us with great RPO and RTOs. However, this introduces a lot more complexity and was an expensive solution to create and manage. This was also 10 years ago before the advent of Cloud Computing. These days there are lower cost and better ways of doing this. For example, did you know that you can replicate your entire Elite*1 environment including the SQL Server to the Microsoft Cloud (Microsoft Azure) using a technology called Azure Site Recovery. You can also fail over and run the environment from there in the event of a disaster. There is a small monthly subscription to pay for each server you replicate. You also need to pay for the storage you use too. However, you don't pay for the compute (that is the server resource) until you run it as part of testing it or in the event of a real disaster recovery situation. The best part is that you can simulate a fail over without impacting the production environment, meaning you can run quarterly tests safely and easily. Management boards love receiving quarterly disaster recovery test reports that demonstrates that their risks are being appropriately managed! If you'd like some help and advice about this, then please get in touch - dan.simms@softcl.com *1 Azure Site Recovery has some pre-requisites such as the source server must be running Windows 2008 R2 or above.

Add your comment