Tag: Availability Groups

  • Setting up a SQL Server Availability Group

    Setting up a SQL Server Availability Group

    In this post, we’ll walk through how to set up a SQL Server Always On Availability Group (AG). I have two Windows Servers – SQL01 and SQL02. Both are set up in a Windows Server Failover Cluster (see this post for more detail on that). Now we’ll walk through the steps that are required within…

    Keep reading

  • Setting Up a Windows Cluster

    Setting Up a Windows Cluster

    In this post, we’ll walk through setting up a Windows Server Failover Cluster (WSFC). This is a requirement of SQL Server Availability Groups, something which we’ll be using on this blog and so I will be setting one up that can be used in the home lab I use to write my blogs. A Windows…

    Keep reading

  • Setup a Non-Domain Windows Cluster

    Setup a Non-Domain Windows Cluster

    This post documents the process of setting up a non-domain Windows Server Failover Cluster, officially known as a Workgroup Cluster. The process is similar to Setting Up a Windows Cluster, however there is a slight difference in this scenario which is that the nodes in the cluster are not part of an Active Directory domain.…

    Keep reading