locked
Availability groups RRS feed

  • Question

  • Hi experts,

    I want to Configure 'Always On'  using multiple instances that are installed on my stand alone desktop.

    Please let me know how this can be done, as I understand that the configuration needs all the instances to be in a single domain and have different IP addressess.

    Thanks

    Monday, September 2, 2013 12:15 PM

Answers

  • Go through the below link where Steps is there that how  to deploy a SQL Server 2012 AlwaysOn Availability Group

    http://www.techrepublic.com/blog/the-enterprise-cloud/sql-server-2012-alwayson-high-availability-database-for-cloud-data-centers/
    • Proposed as answer by DevXYZ Monday, September 2, 2013 5:11 PM
    • Marked as answer by Fanny Liu Tuesday, September 10, 2013 1:55 AM
    Monday, September 2, 2013 12:37 PM
  • Hi Sudhakar,

    No, you can't configure AlwaysOn on multiple INstances on single Server\Desktop.

    Please read the requirements clearly - all the SQL instances should also be part of same Failover Cluster so its quite different from DB Mirroring.

    "Deploying AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster. Each availability replica of a given availability group must reside on a different node of the same WSFC cluster. The only exception is that while being migrated to another WSFC cluster, an availability group can temporarily straddle two clusters."

    Read more: http://technet.microsoft.com/en-us/library/ff877884.aspx

    Incase you want to test & wanna play with Always ON, setup a few machines using HyperV or similar Virtualization technique so that you can create a Failover CLuster and configure it.

    Hyper V getting Started Guide

    http://technet.microsoft.com/en-us/library/cc732470(v=ws.10).aspx


    Sarabpreet Singh Anand

    SQL Server MVP Blog , Personal website

    This posting is provided , "AS IS" with no warranties, and confers no rights.

    Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Fanny Liu Tuesday, September 3, 2013 11:50 AM
    • Marked as answer by Fanny Liu Tuesday, September 10, 2013 1:55 AM
    Monday, September 2, 2013 1:43 PM

All replies