{"id":3845,"date":"2021-11-15T08:00:00","date_gmt":"2021-11-15T05:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=3845"},"modified":"2023-06-09T10:59:43","modified_gmt":"2023-06-09T07:59:43","slug":"pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/","title":{"rendered":"How to setup a SQL Server Always On Availability Group for High Availability"},"content":{"rendered":"<p>Microsoft gives us the ability to do <strong>Replicate <\/strong>our databases as a Group on up to eight Secondary Nodes(servers) as a solution for <strong>High Availability<\/strong>, <strong>Disaster Recovery<\/strong> or also <strong>for reading <\/strong>without occupying the Primary Node. This technology is called <strong>Always On Availability Group<\/strong>. Synchronization is done either <strong>simultaneously for<\/strong> <strong>High-Availability<\/strong> either <strong>asynchronously for<\/strong> <strong>Disaster Recovery<\/strong>. Depending on the version we have, we have different possibilities. <\/p>\n\n\n\n<p>In this article we will see step by step how to install an Always On Availability Group and how we can monitor it.<\/p>\n\n\n\n<p>In detail what an Always On Availability Group is and what features it provides, we can read the article <a href=\"https:\/\/www.dataplatform.gr\/en\/ti-einai-to-always-on-availability-group\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"309\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-80.gif\" alt=\"\" class=\"wp-image-3898\"\/><figcaption class=\"wp-element-caption\">docs.microsoft.com<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<p>Before we start we should have done the following actions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Our Nodes must have joined Active Directory Domain.<\/li>\n\n\n\n<li>SQL Server must have been installed on both Nodes with the user who &quot;raises&quot; the Service being either <strong>Active Directory User <\/strong>either <strong>Managed Service Account<\/strong> and be <strong>common<\/strong> in both. How to do an installation properly can be seen in the article <a href=\"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-sosti-egkatastasi-sqlserver\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/li>\n\n\n\n<li>That they can communicate with each other and that we are not interrupted by a Windows or network firewall.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">The installation<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">Creating the Failover Cluster<\/h4>\n\n\n\n<p>First, let&#039;s go to <strong><em>Server Manager<\/em><\/strong> of Windows Server on both Nodes and select <strong><em>Add roles and features<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-01-1024x630.png\" alt=\"\" class=\"wp-image-3846\" width=\"840\" height=\"516\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-01-1024x630.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-01-300x185.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-01-768x473.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-01.png 1178w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption class=\"wp-element-caption\">01<\/figcaption><\/figure>\n\n\n\n<p>Then we go to the tab <strong>Features <\/strong>and we choose it <strong>Failover Clustering<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"555\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-02.png\" alt=\"\" class=\"wp-image-3847\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-02.png 780w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-02-300x213.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-02-768x546.png 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><figcaption class=\"wp-element-caption\">02<\/figcaption><\/figure>\n\n\n\n<p>After the installation and restart on both Nodes, go to the Server Manager again on one of them and select <strong><em>Tools<\/em><\/strong>, <em><strong>Failover Cluster Manager<\/strong><\/em>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"656\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-04-1024x656.png\" alt=\"\" class=\"wp-image-3848\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-04-1024x656.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-04-300x192.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-04-768x492.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-04.png 1130w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">03<\/figcaption><\/figure>\n\n\n\n<p>When the Failover Cluster Manager opens, select <strong><em>Validate Configuration<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"549\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-5-1024x549.png\" alt=\"\" class=\"wp-image-3849\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-5-1024x549.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-5-300x161.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-5-768x412.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-5.png 1139w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">04<\/figcaption><\/figure>\n\n\n\n<p>Then we add the name of each Node that we want to belong to the Cluster:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"461\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-33.png\" alt=\"\" class=\"wp-image-3850\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-33.png 662w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-33-300x209.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><figcaption class=\"wp-element-caption\">05<\/figcaption><\/figure>\n\n\n\n<p>Then we choose to Validate with all tests:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"663\" height=\"458\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-40.png\" alt=\"\" class=\"wp-image-3851\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-40.png 663w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-40-300x207.png 300w\" sizes=\"auto, (max-width: 663px) 100vw, 663px\" \/><figcaption class=\"wp-element-caption\">06<\/figcaption><\/figure>\n\n\n\n<p>It may show us a warning as in the example we use only one network. After seeing in the report that we don&#039;t have any other important problem, we choose <strong><em>Create the cluster now using the validated nodes...<\/em><\/strong> and <strong><em>Finish<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"454\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-41.png\" alt=\"\" class=\"wp-image-3852\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-41.png 662w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-41-300x206.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><figcaption class=\"wp-element-caption\">07<\/figcaption><\/figure>\n\n\n\n<p>After a while it will open the Create Cluster Wizard there we will define a name for our Cluster and the IP of the Cluster which should belong to the same subnet:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"444\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-9.png\" alt=\"\" class=\"wp-image-3854\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-9.png 662w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-9-300x201.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><figcaption class=\"wp-element-caption\">08<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Creating the Cluster Quorum<\/h4>\n\n\n\n<p>After the Cluster is created we should define one <strong><em>Witness <\/em><\/strong>in the <strong><em>Quorum <\/em><\/strong>which this can be either one <strong><em>file sharing<\/em><\/strong>, either one <em><strong>shared disk<\/strong><\/em> either one <em><strong>Azure Storage Account<\/strong><\/em>. <\/p>\n\n\n\n<p>The job of the Witness is to communicate with both sites and in the event that one fails or the communication between them is lost, to vote for the health of the Cluster so that it continues to be up and running. <\/p>\n\n\n\n<p>So we go to Failover Cluster Manager again, we choose<em><strong> More Actions<\/strong><\/em> and <strong><em>Configure Cluster Quorum Settings\u2026<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"623\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-34-1024x623.png\" alt=\"\" class=\"wp-image-3855\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-34-1024x623.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-34-300x183.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-34-768x467.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-34.png 1060w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">09<\/figcaption><\/figure>\n\n\n\n<p>In the example we will use <strong><em>file share witness<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"453\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-16.png\" alt=\"\" class=\"wp-image-3856\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-16.png 662w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-16-300x205.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><figcaption class=\"wp-element-caption\">10<\/figcaption><\/figure>\n\n\n\n<p>We will need a shared folder that is accessible by the Cluster and all its Nodes.<\/p>\n\n\n\n<p>For the example I chose to create a folder on the server that hosts the Active Directory Controller.<\/p>\n\n\n\n<p>We select right click on the folder, <em><strong>Advanced Sharing\u2026<\/strong><\/em>, <em><strong>Permissions<\/strong><\/em>, <em><strong>Add<\/strong><\/em>, Object Types (<em><strong>Computers<\/strong><\/em>), Location (the <em><strong>domain<\/strong><\/em>), we search for Nodes and add them with <em><strong>Allow Full Control<\/strong><\/em>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"414\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-36-1024x414.png\" alt=\"\" class=\"wp-image-3858\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-36-1024x414.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-36-300x121.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-36-768x310.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-36.png 1259w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">11<\/figcaption><\/figure>\n\n\n\n<p>We do the same in the security tab and add the name of the Cluster:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"468\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-37.png\" alt=\"\" class=\"wp-image-3897\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-37.png 704w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-37-300x199.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><figcaption class=\"wp-element-caption\">12<\/figcaption><\/figure>\n\n\n\n<p>Then in the Cluster Quorum wizard we set the <em><strong>path <\/strong><\/em>with the file share and select <em><strong>Next<\/strong><\/em> until its creation is complete:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"664\" height=\"459\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-35.png\" alt=\"\" class=\"wp-image-3857\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-35.png 664w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-35-300x207.png 300w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><figcaption class=\"wp-element-caption\">13<\/figcaption><\/figure>\n\n\n\n<p>After the creation of the Witness is complete, we go back to the Failover Cluster Manager to make sure that no problem has appeared to us:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"758\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-39-1024x758.png\" alt=\"\" class=\"wp-image-3859\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-39-1024x758.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-39-300x222.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-39-768x568.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-39.png 1057w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">14<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Create the Always On Availability Group<\/h4>\n\n\n\n<p>Let&#039;s go to <strong><em>SQL Server Configuration Manager<\/em><\/strong> on both Nodes and we choose <strong><em>SQL Server Services<\/em><\/strong>, right click on its service <strong><em>SQL Server<\/em><\/strong> and <strong><em>Properties<\/em><\/strong>. There you should on the tab<em><strong> Always On Availability Group<\/strong><\/em> to choose it <strong><em>Enable Always On Availability Groups<\/em><\/strong>. In case we have not yet changed the user that starts the service from the Windows default to its user or managed service <strong>Active Directory<\/strong> we should do it now on the tab <strong><em>Log On<\/em><\/strong> (in the example I have defined a managed service named DATAPLATFORM\\sqlservice on all nodes as it must be common):<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"605\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-75-1024x605.png\" alt=\"\" class=\"wp-image-3860\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-75-1024x605.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-75-300x177.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-75-768x454.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-75.png 1104w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">15<\/figcaption><\/figure>\n\n\n\n<p>Then again in SQL Server Configuration Manager we choose <strong><em>SQL Server Network Configuration<\/em><\/strong>, <strong><em>Protocols for MSSQLSERVER<\/em><\/strong>, right click on <em><strong>TCP\/IP<\/strong><\/em> and <em><strong>Enabled Yes<\/strong><\/em>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"719\" height=\"674\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-45.png\" alt=\"\" class=\"wp-image-3861\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-45.png 719w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-45-300x281.png 300w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><figcaption class=\"wp-element-caption\">16<\/figcaption><\/figure>\n\n\n\n<p>To create the Availability Group we now connect to <strong>SQL Server Management Studio<\/strong> from the Primary Node (optional), right-click On <em><strong>Always On High Availability<\/strong><\/em> , <strong><em>Availability Groups<\/em><\/strong> and <em><strong>New Availability Group Wizard\u2026<\/strong><\/em>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"496\" height=\"451\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-19.png\" alt=\"\" class=\"wp-image-3862\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-19.png 496w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-19-300x273.png 300w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><figcaption class=\"wp-element-caption\">17<\/figcaption><\/figure>\n\n\n\n<p>In the wizard that will appear, define the name of the Availability Group and select it <strong><em>Database Level Health Detection<\/em><\/strong> (Cluster type must be Windows Server Failover Cluster):<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"742\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-26.png\" alt=\"\" class=\"wp-image-3863\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-26.png 813w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-26-300x274.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-26-768x701.png 768w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><figcaption class=\"wp-element-caption\">18<\/figcaption><\/figure>\n\n\n\n<p>We choose the bases we want to Replicate, if we have Enterprise Edition we can choose more than one in the same group:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"742\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-44.png\" alt=\"\" class=\"wp-image-3864\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-44.png 813w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-44-300x274.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-44-768x701.png 768w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><figcaption class=\"wp-element-caption\">19<\/figcaption><\/figure>\n\n\n\n<p>Then on the tab <strong><em>Replicas<\/em><\/strong> we also add the second Node with the selection <em><strong>Add Replica\u2026<\/strong><\/em> .In this tab we can choose whether it will do automatic failover, whether the replication will be synchronous or asynchronous and whether the Secondary will be accessible for reading (depending on the version):<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"714\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-22.png\" alt=\"\" class=\"wp-image-3865\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-22.png 816w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-22-300x263.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-22-768x672.png 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><figcaption class=\"wp-element-caption\">20<\/figcaption><\/figure>\n\n\n\n<p>In the tab <em><strong>Backup Preferences<\/strong><\/em> (depending on the version) we can define if we want our database to take backups to Secondary instead of Primary and with what priority:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"898\" height=\"739\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-46.png\" alt=\"\" class=\"wp-image-3866\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-46.png 898w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-46-300x247.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-46-768x632.png 768w\" sizes=\"auto, (max-width: 898px) 100vw, 898px\" \/><figcaption class=\"wp-element-caption\">21<\/figcaption><\/figure>\n\n\n\n<p>In the tab <strong><em>Listener <\/em><\/strong>we create the listener with which we can connect with a common DNS or IP to any Node according to which one is Primary (active) at the moment or if we want Read-Only access. We choose it <strong><em>name<\/em><\/strong>, <strong><em>door<\/em><\/strong>, as Network Mode <em><strong>Static IP<\/strong><\/em> and we do <strong><em>Add\u2026 <\/em><\/strong>a specific IP belonging to the subnet:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"815\" height=\"710\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-76.png\" alt=\"\" class=\"wp-image-3870\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-76.png 815w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-76-300x261.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-76-768x669.png 768w\" sizes=\"auto, (max-width: 815px) 100vw, 815px\" \/><figcaption class=\"wp-element-caption\">22<\/figcaption><\/figure>\n\n\n\n<p>In the tab <strong><em>Read-Only Routing<\/em><\/strong> in case we want to have Read-Only access to Secondary we define them <strong><em>URL <\/em><\/strong>which will also be accessible as a Read-Only Routing List the order that will route us to Read-Only intent depending on the Instance we are connected to:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"739\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-65.png\" alt=\"\" class=\"wp-image-3874\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-65.png 816w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-65-300x272.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-65-768x696.png 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><figcaption class=\"wp-element-caption\">23<\/figcaption><\/figure>\n\n\n\n<p>In the next tab we define the way the base will be transferred to the Secondary. We have the option for <strong><em>Automatic Seeding<\/em><\/strong> if the paths are the same without having to do anything else, the selection <em><strong>Full<\/strong><\/em> where we will define file share paths in which the backups and the selection will be placed <em><strong>Join only <\/strong><\/em>which is for the cases where we have transferred and restored the database ourselves but without having done recovery (that is, it is not yet accessible):<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-25.png\" alt=\"\" class=\"wp-image-3869\" width=\"815\" height=\"710\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-25.png 815w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-25-300x261.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-25-768x669.png 768w\" sizes=\"auto, (max-width: 815px) 100vw, 815px\" \/><figcaption class=\"wp-element-caption\">24<\/figcaption><\/figure>\n\n\n\n<p>If everything goes well, we will have all Results Success:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"895\" height=\"741\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-48.png\" alt=\"\" class=\"wp-image-3871\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-48.png 895w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-48-300x248.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-48-768x636.png 768w\" sizes=\"auto, (max-width: 895px) 100vw, 895px\" \/><figcaption class=\"wp-element-caption\">25<\/figcaption><\/figure>\n\n\n\n<p>Now if we go to <strong>SQL Server Management Studio<\/strong> and double click on <strong><em>Always On High Availability<\/em><\/strong>, double click on <strong><em>Availability Groups<\/em><\/strong>, right click on his name<strong><em> <\/em><\/strong>Availability Group <em><strong>Show Dashboard<\/strong><\/em> we will see that the Availability Group has been created and is healthy:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"435\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-64-1024x435.png\" alt=\"\" class=\"wp-image-3872\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-64-1024x435.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-64-300x127.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-64-768x326.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-64.png 1038w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">26<\/figcaption><\/figure>\n\n\n\n<p>We can also see this information with T-SQL with the following query:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">SELECT ag.name AS [AG_Name], ar.replica_server_name AS [ReplicaServerName], ar.availability_mode_desc AS [AvailabilityMode], adc.[database_name], \n       hars.role_desc as [Role],  drs.synchronization_state_desc as [SynchronizationState], drs.is_commit_participant as [IsCommit], \n\t   drs.synchronization_health_desc as [SyncHealth],drs.database_state_desc as [DatabaseState],\n\t   drs.last_commit_time as [Last Commit Update Time]\nFROM sys.dm_hadr_database_replica_states AS drs WITH (NOLOCK)\nINNER JOIN sys.availability_databases_cluster AS adc WITH (NOLOCK)\nON drs.group_id = adc.group_id \nAND drs.group_database_id = adc.group_database_id\nINNER JOIN sys.availability_groups AS ag WITH (NOLOCK)\nON ag.group_id = drs.group_id\nINNER JOIN sys.availability_replicas AS ar WITH (NOLOCK)\nON drs.group_id = ar.group_id \nAND drs.replica_id = ar.replica_id\nINNER JOIN sys.dm_hadr_availability_replica_states hars \nON drs.replica_id = hars.replica_id \nwhere 1=1\nORDER BY ag.name, ar.replica_server_name, adc.[database_name] OPTION (RECOMPILE);<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1007\" height=\"140\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-62.png\" alt=\"\" class=\"wp-image-3873\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-62.png 1007w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-62-300x42.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-62-768x107.png 768w\" sizes=\"auto, (max-width: 1007px) 100vw, 1007px\" \/><figcaption class=\"wp-element-caption\">27<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">What happens if the Primary Node goes down if we have selected Automatic Failover?<\/h4>\n\n\n\n<p>If for some reason the Primary node goes down, we will see on the Dashboard that the Secondary node has become Primary and the base in the former Primary is in Not Synchronizing State:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"947\" height=\"442\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-70.png\" alt=\"\" class=\"wp-image-3875\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-70.png 947w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-70-300x140.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-70-768x358.png 768w\" sizes=\"auto, (max-width: 947px) 100vw, 947px\" \/><figcaption class=\"wp-element-caption\">28<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"94\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-71.png\" alt=\"\" class=\"wp-image-3876\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-71.png 939w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-71-300x30.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-71-768x77.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><figcaption class=\"wp-element-caption\">29<\/figcaption><\/figure>\n\n\n\n<p>If we restore the Node after a while we will see that the Availability group is Healthy, the second Node remains as Primary but the base on the first Node has returned as Synchronized.<\/p>\n\n\n\n<p>In case we want to turn the first Node as Primary, we select it <strong><em>Start Failover Wizard<\/em><\/strong> (we never failover through the Windows Server Failover Cluster Manager) :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"947\" height=\"425\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-72.png\" alt=\"\" class=\"wp-image-3877\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-72.png 947w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-72-300x135.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-72-768x345.png 768w\" sizes=\"auto, (max-width: 947px) 100vw, 947px\" \/><figcaption class=\"wp-element-caption\">30<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">How do we connect to the Listener in a read-only Secondary<\/h4>\n\n\n\n<p>To connect to the Listener via SQL Server Management Studio, simply put its DNS or IP in the Server name. To declare that we want to connect for Read-Only we should select the option <strong><em>Options<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"475\" height=\"516\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-69.png\" alt=\"\" class=\"wp-image-3878\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-69.png 475w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-69-276x300.png 276w\" sizes=\"auto, (max-width: 475px) 100vw, 475px\" \/><figcaption class=\"wp-element-caption\">31<\/figcaption><\/figure>\n\n\n\n<p>And on the tab <strong>Additional Connection Parameters<\/strong> to declare <strong>ApplicationIntent=ReadOnly<\/strong>. Thus, the select queries that we will execute in this session will be executed as a priority in Secondary:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"515\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-68.png\" alt=\"\" class=\"wp-image-3879\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-68.png 473w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/10\/wsag-68-276x300.png 276w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><figcaption class=\"wp-element-caption\">32<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"> How we create new logins<\/h4>\n\n\n\n<p>We must not forget that new logins and jobs are not transferred to Secondary automatically, so we must either have an SSIS package in Job that will create them or we must create them manually.<\/p>\n\n\n\n<p>In order for a login to be correctly transferred after we have created it in Primary, we run the following query in Primary by putting in <em>where <\/em>the name of the login we created for the DDL script to create for us:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">SELECT N'CREATE LOGIN ['+sp.[name]+'] WITH PASSWORD=0x'+\n    CONVERT(nvarchar(max), l.password_hash, 2)+N' HASHED, '+\n    N'SID=0x'+CONVERT(nvarchar(max), sp.[sid], 2)+N';',\n\tN'ALTER LOGIN ['+sp.[name]+'] WITH PASSWORD=0x'+CONVERT(nvarchar(max), l.password_hash, 2)+N' HASHED UNLOCK ,CHECK_POLICY=OFF;'\nFROM master.sys.server_principals AS sp\nINNER JOIN master.sys.sql_logins AS l ON sp.[sid]=l.[sid]\nWHERE sp.name = 'test';  -- \u03a4\u03bf \u03b1\u03bb\u03bb\u03ac\u03b6\u03bf\u03c5\u03bc\u03b5 \u03b1\u03bd\u03ac\u03bb\u03bf\u03b3\u03b1 \u03bc\u03b5 \u03c4\u03bf \u03cc\u03bd\u03bf\u03bc\u03b1 \u03c4\u03bf\u03c5 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b7 \u03c0\u03bf\u03c5 \u03b8\u03ad\u03bb\u03bf\u03c5\u03bc\u03b5 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bc\u03b5<\/pre>\n\n\n\n<p>After running it, select the column with the result and run the DDL in the Secondary to create the login correctly there:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"88\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/11\/wsag-70.png\" alt=\"\" class=\"wp-image-4017\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/11\/wsag-70.png 411w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/11\/wsag-70-300x64.png 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><figcaption class=\"wp-element-caption\">33<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Bonus Script (For Backup \/ Index Maintenance \/ Database Integrity Check SQL Server Agent Jobs)<\/h2>\n\n\n\n<p>With the following script that I have made, with just one click, it installs it <a href=\"https:\/\/ola.hallengren.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">MaintenanceSolution<\/a> by Ola Hallengren along with ready configured jobs for <strong>Backup<\/strong> ,<strong>Database Integrity<\/strong> and <strong>Index Optimize<\/strong> with optimal parameters and timing.<\/p>\n\n\n\n<p>Backup jobs are created <strong>disabled<\/strong> as we may have another solution for backup with a 3rd party tool. It also checks for <strong>Availability Group<\/strong> so that they run only if it is the <em>Preferred Backup Replica <\/em>(for backup \/ database integrity) and if it is <em>Primary Replica<\/em> (for Index Optimize).<\/p>\n\n\n\n<p>All we need to do is run the following script on each SQL Server Instance:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-7881d49c-15ce-49dd-bd30-265f0c6b586d\" href=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/09\/MaintenanceSolution-ReadyToPlay.txt\">MaintenanceSolution-ReadyToPlay<\/a><a href=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2022\/09\/MaintenanceSolution-ReadyToPlay.txt\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-7881d49c-15ce-49dd-bd30-265f0c6b586d\">Download<\/a><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Sources:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">What is an Always On availability group?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Prerequisites, Restrictions, and Recommendations for Always On availability groups<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/availability-group-listener-overview?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">What is an availability group listener?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-server\/failover-clustering\/manage-cluster-quorum\" target=\"_blank\" rel=\"noreferrer noopener\">Configure and manage quorum<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/always-on-availability-groups-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Always On availability groups: a high-availability and disaster-recovery solution<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Microsoft provides us with the ability to Replicate our databases as a Group on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery or even for reading without the Primary Node being occupied. This technology is called Always On Availability Group. Synchronization is done either synchronously for High-Availability or asynchronously [...]<\/p>","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,15],"tags":[156,29,66,65,23,30,492,6],"class_list":["post-3845","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ms-sqlserver","tag-always-on-availability-group","tag-databases","tag-disaster-recovery","tag-high-availability","tag-microsoft","tag-rdbms","tag-replication","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u0397 Microsoft \u03bc\u03b1\u03c2 \u03c0\u03b1\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 Replicate \u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b1\u03c2 \u03c3\u03b1\u03bd \u03ad\u03bd\u03b1 Group \u03c3\u03b5 \u03ad\u03c9\u03c2 \u03bf\u03ba\u03c4\u03ce Secondary Nodes(servers) \u03c9\u03c2 \u03bc\u03af\u03b1 \u03bb\u03cd\u03c3\u03b7 \u03b3\u03b9\u03b1 High Availability, Disaster Recovery \u03ae \u03ba\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03b1\u03bd\u03ac\u03b3\u03bd\u03c9\u03c3\u03b7 \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03b1\u03c0\u03b1\u03c3\u03c7\u03bf\u03bb\u03b5\u03af\u03c4\u03b1\u03b9&nbsp;\u03c4\u03bf Primary Node. \u0397 \u03c4\u03b5\u03c7\u03bd\u03bf\u03bb\u03bf\u03b3\u03af\u03b1 \u03b1\u03c5\u03c4\u03ae \u03bf\u03bd\u03bf\u03bc\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 Always On Availability Group. O \u03c3\u03c5\u03b3\u03c7\u03c1\u03bf\u03bd\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03b5\u03af\u03c4\u03b5 \u03c3\u03c5\u03b3\u03c7\u03c1\u03cc\u03bd\u03b1 \u03b3\u03b9\u03b1 High-Availability \u03b5\u03af\u03c4\u03b5 \u03b1\u03c3\u03cd\u03c7\u03c1\u03bf\u03bd\u03b1 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-15T05:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T07:59:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability\",\"datePublished\":\"2021-11-15T05:00:00+00:00\",\"dateModified\":\"2023-06-09T07:59:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/\"},\"wordCount\":485,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"keywords\":[\"Always On Availability Group\",\"Databases\",\"Disaster Recovery\",\"High Availability\",\"Microsoft\",\"RDBMS\",\"Replication\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"datePublished\":\"2021-11-15T05:00:00+00:00\",\"dateModified\":\"2023-06-09T07:59:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability - DataPlatform.gr","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability - DataPlatform.gr","og_description":"\u0397 Microsoft \u03bc\u03b1\u03c2 \u03c0\u03b1\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 Replicate \u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b1\u03c2 \u03c3\u03b1\u03bd \u03ad\u03bd\u03b1 Group \u03c3\u03b5 \u03ad\u03c9\u03c2 \u03bf\u03ba\u03c4\u03ce Secondary Nodes(servers) \u03c9\u03c2 \u03bc\u03af\u03b1 \u03bb\u03cd\u03c3\u03b7 \u03b3\u03b9\u03b1 High Availability, Disaster Recovery \u03ae \u03ba\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03b1\u03bd\u03ac\u03b3\u03bd\u03c9\u03c3\u03b7 \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03b1\u03c0\u03b1\u03c3\u03c7\u03bf\u03bb\u03b5\u03af\u03c4\u03b1\u03b9&nbsp;\u03c4\u03bf Primary Node. \u0397 \u03c4\u03b5\u03c7\u03bd\u03bf\u03bb\u03bf\u03b3\u03af\u03b1 \u03b1\u03c5\u03c4\u03ae \u03bf\u03bd\u03bf\u03bc\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 Always On Availability Group. O \u03c3\u03c5\u03b3\u03c7\u03c1\u03bf\u03bd\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03b5\u03af\u03c4\u03b5 \u03c3\u03c5\u03b3\u03c7\u03c1\u03cc\u03bd\u03b1 \u03b3\u03b9\u03b1 High-Availability \u03b5\u03af\u03c4\u03b5 \u03b1\u03c3\u03cd\u03c7\u03c1\u03bf\u03bd\u03b1 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-11-15T05:00:00+00:00","article_modified_time":"2023-06-09T07:59:43+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability","datePublished":"2021-11-15T05:00:00+00:00","dateModified":"2023-06-09T07:59:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/"},"wordCount":485,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","keywords":["Always On Availability Group","Databases","Disaster Recovery","High Availability","Microsoft","RDBMS","Replication","SQL Server"],"articleSection":["Databases","Microsoft SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/","url":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/","name":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","datePublished":"2021-11-15T05:00:00+00:00","dateModified":"2023-06-09T07:59:43+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-ena-sql-server-always-on-availability-group-gi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03ad\u03bd\u03b1 SQL Server Always On Availability Group \u03b3\u03b9\u03b1 High Availability"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=3845"}],"version-history":[{"count":1,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3845\/revisions"}],"predecessor-version":[{"id":5475,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3845\/revisions\/5475"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=3845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=3845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=3845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}