Post reply

Always On

  • March 23, 2016 at 8:29 am

    #317216

    Hi,

    We are using a SQL Server Failover Cluster instance (2012) through Windows Server 2008 R2 to run our applications.

    Do you know if can I use AlwaysON in this cluster ? Or should I build another cluster?

  • March 23, 2016 at 11:36 pm

    #1867316

    Hi

    You may refer to the link below.

    https://msdn.microsoft.com/en-us/library/ff878487.aspx

    There is a section in the article about prerequisites and restrictions for using a SQL Server Failover Cluster Instance (FCI) to host an availability replica.

    Best Regards,

    Ricky

  • March 24, 2016 at 3:09 pm

    #1867645

    Typically AGs are setup (as basically mirroring) between stand alone instances on top of WFC nodes, not clustered SQL instances.

    HTH

  • March 25, 2016 at 5:37 am

    #1867711

    The cluster MUST be a Windows cluster, but you don't have to have SQL clustered in order to use AG. You can have a SQL cluster use AG, but ... what's the point if the entire instance is going to fail over to the new server anyway?

    The recommended way to do it is have the windows cluster set up with all the machines and then use stand alone SQL installs. Don't use shared SAN storage (like the SQL clusters do) either.

    But if you want to experiment on clustered SQL instances, feel free. And please let us know how it works out.

    EDIT: Changed a word.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • March 28, 2016 at 12:42 pm

    #1868044

    SQL Server Availability groups set requires two or more standalone SQL Server with its own storage.The fail over cluster method users shared disk and SQL Servers are also set up a cluster node. Its more work to build from Failover cluster than to create a new availability group. If you environment is set up in HA mode you might not have time to do all the steps. Some of the steps will include

    1. back up all the databases, roles, users, jobs et al

    2. remove all the nodes in the cluster

    3. The primary will be tied the network name , so all has to uninstalled

    4. Remove the shared storage disk from cluster

    5. Follow steps to create SQL server installation and the availability group set up

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply