locked
SQL 2012 AlwaysOn RRS feed

  • Question

  • We have the production SQL instance on a single Azure VM now and we are planning to implement the SQL AlwaysOn.

    To minimize the risk we are thinking about creating two more VMs then configure the AlwaysOn then migrate the existing DBs from the current SQL server.

    Is this the right way to do or any other better ways to accomplish this?

    Thank you.

    Wednesday, April 2, 2014 9:26 PM

Answers

  • Hi NJRCI,

    According to your description, you can configure AlwaysOn Availability Groups in Azure Virtual Machines. Azure virtual machines (VMs) with SQL Server can help you to lower the cost of a high availability and disaster recovery (HADR) database system. All availability replicas running in Azure VMs for high availability within the same Azure datacenter. You need to configure a domain controller in addition to the SQL Server virtual machines because Windows Server Failover Clustering (WSFC) requires an Active Directory domain. For more information, see: AlwaysOn Availability Groups in Windows Azure (GUI)

    This article provides information on how to migrate an existing on-premise SQL Server database built on Windows Server platform to SQL Server in Azure Virtual Machines (VMs).

    http://msdn.microsoft.com/en-us/library/jj156165.aspx

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by Sofiya Li Thursday, April 10, 2014 1:51 AM
    Friday, April 4, 2014 8:24 AM