locked
SQL 2014 Setup RRS feed

  • Question

  • Hi,

    We are in process of setting up our production environment which will be based on MS SQL server 2014.   We plan to have 4 servers.

    1. Database Primary

    2. Database Replica ( Failover Cluster on non-shared storage) ( Sync Mode)

    3. Database Report Server ( ASync Mode, Read Only)

    4. Database DR Server ( ASync Mode)

    SQL Standard support 2 node failover cluster.

     

    Question 1: Can I add the third sever ( Database Report) to the environment to run the reports in SQL Standard.

    Question 2: Do I need to purchase the per core license for Failover cluster Replica server which will be passive.

    Question 3:  Can I add the fourth server to the existing environment for DR server in SQL standard.

    Thanks & Regards

    Mohammed Ilyas

    mohammed.ilyas@saudienaya.com

    Thursday, December 17, 2015 9:20 AM

Answers

  • Hi Mohammed,

    Could you please clarify that if you want to set up AlwaysOn Failover Cluster instances or AlwaysOn Availability Group?

    Firstly, If you want to use AlwaysOn Availability Groups to replicate SQL Server databases, please note that each replica in an AlwaysOn Availability Group must be licensed with SQL Server Enterprise Edition. In other words, with SQL Server 2014 Enterprise, you can add the third server to the environment to run reports and add fourth server to the existing environment for DR. However, SQL Server 2016 adds Availability Groups in Standard Edition, and it limits to two nodes only. For more details, please review this blog.

    Secondly, if you
    want to set up AlwaysOn Failover Cluster instances, as your post, SQL Server 2014 Standard Edition allows for a two-node failover cluster instance (FCI).

    AlwaysOn Failover Cluster Instances leverages Windows Server Failover Clustering (WSFC) functionality to provide local high availability through redundancy at the server-instance level. Also please note that contrary to the AlwaysOn availability group, an FCI must use shared storage between all nodes of the FCI for database and log storage.

    Thirdly, an FCI can leverage AlwaysOn Availability Groups to provide remote disaster recovery at the database level. For more information, see Failover Clustering and AlwaysOn Availability Groups (SQL Server).

    In addition, regarding to the license issues, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations.

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Friday, December 18, 2015 5:41 AM