Skip to Content
Former Member
May 13, 2014 at 09:47 AM

MSSQL Disaster recovery scenario



I am trying to implement a disaster recovery scenario for my customer. Their landscape contains ERP 6.0 EHP7, CRM 7.0 EHP3, Netweaver 7.4 Portal, BO 4.1 and Solman 7.1

All of their systems are installed on MSSQL 2012 SP1 CU7 and Windows Server 2008 R2.

They want asynchronous mirroring as disaster recovery solution and as for ERP system they want their production systems will use AlwaysOn feature and secondary mirror as backup server from AlwaysOn setup. Also same system will use asynchronous mirroring to disaster site.

How can I achieve that? I found notes about what is AlwaysOn and what is mirroring but there are no installation and configuration guides to how to do it. I also have to test how to turn back from disaster site to main site.

Anyone got experience and good documentation on implementing AlwaysOn and asynchronous mirroring at the same system and how to turn back from disaster to prod site?

Best regards