SQL SERVER 2014 DISASTER RECOVERY

Question

Hi All,

Please let me know on below topic.

SQL SERVER 2014 DISASTER RECOVERY

Answer 1

Hello,

Please read the following resources:

http://blogs.technet.com/b/dataplatforminsider/archive/2014/04/08/sql-server-2014-brings-on-premises-and-cloud-database-together-to-improve-data-availability-and-disaster-recovery.aspx

http://blogs.technet.com/b/francesco_diaz/archive/2014/02/06/sql-server-2014-alwayson-availability-groups-add-azure-replica-wizard-in-action.aspx

http://blogs.technet.com/b/francesco_diaz/archive/2013/11/15/sql-server-2014-ctp2-alwayson-availability-groups-hybrid-it-scenario-using-windows-azure.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi All,

Please let me know on below topic.

SQL SERVER 2014 DISASTER RECOVERY

AlwaysOn Availability Groups introduced in SQL Server 2012, is a high availability and disaster recovery solution. It has two availability modes: Synchronous & Asynchronous commit modes

Asynchronous commit mode is a disaster recovery solution.

Please have a look at these links:

AlwaysOn Availability Groups

Overview of AlwaysOn Availability Groups

Getting Started with AlwaysOn Availability Groups

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

---

T-SQL Articles
T-SQL e-book by TechNet Wiki Community
T-SQL blog