SQL Server Always on

Mohammad Moeini 46 Reputation points
2023-08-27T06:39:49.1766667+00:00

Hi everybody ,

I have some SQL server in my environment and we are planning SQL server always on feature but I have some problem and I want to know should all of person that who plan this feature be a system admin ?

thanks'

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,655 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Erland Sommarskog 100.8K Reputation points MVP
    2023-08-27T09:43:29.6366667+00:00

    First of all, "Always on" is an umbrella name for two technologies for HA (High Availability): Failover cluster instances (FCI) and Availability Groups (AG). Most people incorrectly use Always On to mean AG, so I will assume that this is what you have in mind.

    To use AGs for HA, you first in need a Windows Failover Cluster, to set up that, you need to be a Windows administrator. I don't know on the top of my head, the exact permissions needed to create an availability group in SQL Server, but if you look at the topic for CREATE AVAILABILITY GROUP to find out. But in practice, setting up an AG is a task for sysadmin.

    0 comments No comments

  2. Rahul Randive 8,181 Reputation points Microsoft Employee
    2023-08-27T12:03:18.67+00:00

    Hi Mohammad Moeini •,

    Here's a concise YouTube video that demonstrates "how to configure SQL Server Always On for Azure VM", along with the "Step-By-Step: Creating a SQL Server Always On Availability Group" community blog.

    YouTube- https://youtu.be/nhUMWYOMD_s?si=cO_dc5KA2QbMCeMl

    Blog- https://techcommunity.microsoft.com/t5/itops-talk-blog/step-by-step-creating-a-sql-server-always-on-availability-group/ba-p/648772

    I believe these resources will provide you with a solid understanding of the setup process, and your DBA should be able to offer further assistance.

    Hope this helps!

    Thank you

    0 comments No comments

  3. ZoeHui-MSFT 32,506 Reputation points
    2023-08-28T05:29:07.83+00:00

    Hi Mohammad Moeini

    This article describes considerations for deploying Always On availability groups, including prerequisites, restrictions, and recommendations for host computers, Windows Server failover clusters (WSFC), server instances, and availability groups. For each of these components security considerations and required permissions, if any, are indicated.

    Prerequisites, Restrictions, and Recommendations for Always On availability groups

    You may take a reference to.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  4. Alex Bykovskyi 1,681 Reputation points
    2023-08-29T19:57:28.5366667+00:00

    Hey,

    SQL Server has multiple options to configure high availability. You can use either Availability Groups or Failover Cluster Instances. Check for more information: https://learn.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver16

    Configuration depends on your licenses, servers etc. The following article compares FCI vs AG: https://www.starwindsoftware.com/blog/always-on-availability-groups-vs-failover-cluster

    Note. FCI requires shared storage. You can use either a dedicated SAN or VSAN. S2D or StarWind VSAN can be used as a VSAN option. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-storage-spaces-direct-manually-configure?view=azuresql

    https://www.starwindsoftware.com/starwind-virtual-san

    Cheers,    
    Alex Bykovskyi    
    StarWind Software    
    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    0 comments No comments