VMware Cloud Community
sibdba
Contributor
Contributor
‎10-26-2011 02:57 PM

VMWare disaster recovery planning

Hi Guys – I am in the process of developing a disaster recovery plan and wondering what would happen to my production VM where SQL is running if something goes wrong to the VM Operating System level (e.g. blue screen, not able to boot the server).

Thanks!

0 Kudos
1 Reply
AureusStone
Expert
Expert
‎10-26-2011 04:13 PM

I presume you are using MSSQL?

If you have an application fault on your DB server, your application servers that depend on the DB will fail.  This is no different to a physical environment.

If you need a higher level of resilency for application faults consider SQL mirroring.

http://technet.microsoft.com/en-us/library/dd207314.aspx

If you can mirror across the WAN, even better. :smileycool:

0 Kudos