{"id":350,"date":"2020-10-01T09:46:09","date_gmt":"2020-10-01T09:46:09","guid":{"rendered":"https:\/\/kindsonthegenius.com\/mssql\/?p=350"},"modified":"2026-07-04T21:50:20","modified_gmt":"2026-07-04T21:50:20","slug":"ms-sql-server-high-availability","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/","title":{"rendered":"MS SQL Server &#8211; High Availability"},"content":{"rendered":"<p><!-- ktg-updated-banner --><\/p>\n<div class=\"ktg-updated-banner\" style=\"margin:1em 0;padding:0.75em 1em;background:#eff6ff;border-left:4px solid #3b82f6;border-radius:4px;\">\n<p><strong>Updated July 4, 2026:<\/strong> Reviewed for accuracy; notes added for SQL Server 2022\/2025 where applicable.<\/p>\n<\/div>\n<p>High Availability(HA) describe methods used to ensure that the database is available close to 24\/7 365 days under every circumstance. This is a very important aspect of a DBAs work. In this tutorials, we would examine 5 different technologies to achieve high availability.<\/p>\n<ol>\n<li><a href=\"#t1\">Database Replication<\/a><\/li>\n<li><a href=\"#t2\">Log Shipping<\/a><\/li>\n<li><a href=\"#t3\">Database Mirroring<\/a><\/li>\n<li><a href=\"#t4\">Clustering<\/a><\/li>\n<li><a href=\"#t5\">Always On Availability<\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h4><strong id=\"t1\">1. Database Replication<\/strong><\/h4>\n<p>In this approach, we copy object from a database to another database. These objects can be tables, view, stored procedures etc. It can be scheduled to run as SQL Server Agent jobs. There are three components which includes<\/p>\n<ul>\n<li><strong>Publisher<\/strong> &#8211; this is the primary server holding the data to be replicated.<\/li>\n<li><strong>Distributor<\/strong> &#8211; this is an optional database that stores the replicated data from the publisher<\/li>\n<li><strong>Subscriber<\/strong> &#8211; this is the destination server where data is copied to<\/li>\n<\/ul>\n<p>You can find replication in SQL Server Management studio a shown in the figure below:<\/p>\n<figure id=\"attachment_352\" aria-describedby=\"caption-attachment-352\" style=\"width: 534px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-352\" src=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png?resize=534%2C347&#038;ssl=1\" alt=\"Replication in MS SQL Server\" width=\"534\" height=\"347\" srcset=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png?w=534&amp;ssl=1 534w, https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png?resize=300%2C195&amp;ssl=1 300w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/a><figcaption id=\"caption-attachment-352\" class=\"wp-caption-text\">Replication in MS SQL Server<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h4><strong id=\"t2\">2. Database Mirroring<\/strong><\/h4>\n<p>In database mirroring, a database is copied from a primary instance called the principal to a secondary instance. Here, there are three components involved:<\/p>\n<ul>\n<li><strong>Principal<\/strong> &#8211; this is the primary instance containing the original data<\/li>\n<li><strong>Mirror<\/strong> &#8211; this is the instance where data would be mirrored to<\/li>\n<li><strong>Witness<\/strong> &#8211; optional instance that contains additional information<\/li>\n<\/ul>\n<p>Database mirroring may be removed in subsequent versions of SQL Server. Would be replaced with Always On Availability.<\/p>\n<p>However, to configure database mirroring, you can right-click on the database, Tasks &gt; Mirror. This is shown below:<\/p>\n<figure id=\"attachment_353\" aria-describedby=\"caption-attachment-353\" style=\"width: 666px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.37.00.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\" wp-image-353\" src=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.37.00.png?resize=666%2C449&#038;ssl=1\" alt=\"Database Mirroring in SQL Server Management Studio\" width=\"666\" height=\"449\" srcset=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.37.00.png?w=811&amp;ssl=1 811w, https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.37.00.png?resize=300%2C202&amp;ssl=1 300w, https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.37.00.png?resize=768%2C518&amp;ssl=1 768w\" sizes=\"auto, (max-width: 666px) 100vw, 666px\" \/><\/a><figcaption id=\"caption-attachment-353\" class=\"wp-caption-text\">Database Mirroring in SQL Server Management Studio<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h4><strong id=\"t3\">3. Log Shipping<\/strong><\/h4>\n<p>This is a high availability and disaster recovery(DR) approach for SQL Server database. As the name shows, this method requires backup of database transaction logs. This backup is configured to run at intervals using SQL Server job. The following three components are involved:<\/p>\n<ul>\n<li><strong>Primary Server<\/strong> &#8211; this is source server holding the original database<\/li>\n<li><strong>Secondary Server<\/strong> &#8211; this is the destination server where the transaction logs are backed up to<\/li>\n<li><strong>Monitor Server<\/strong> &#8211; an optional server used for\u00a0 monitoring the log shipping status<\/li>\n<\/ul>\n<p>You can find Log Shipping in SQL server management studio when you right-click on the database &gt; Tasks &gt; Ship Transaction Logs. See figure below:<\/p>\n<figure id=\"attachment_354\" aria-describedby=\"caption-attachment-354\" style=\"width: 811px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.39.25.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-354\" src=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.39.25.png?resize=811%2C515&#038;ssl=1\" alt=\"Transaction Log Shipping in SQL Server\" width=\"811\" height=\"515\" srcset=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.39.25.png?w=811&amp;ssl=1 811w, https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.39.25.png?resize=300%2C191&amp;ssl=1 300w, https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.39.25.png?resize=768%2C488&amp;ssl=1 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/a><figcaption id=\"caption-attachment-354\" class=\"wp-caption-text\">Transaction Log Shipping in SQL Server<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h4><strong id=\"t4\">4. MS SQL Database Clustering<\/strong><\/h4>\n<p>Here we are talking about Failover Clustering. In this approach, we create two or more servers(cluster) with similar access to shared storage disks that stored the database files. Here the servers are described as nodes and communicate via a network.<\/p>\n<ul>\n<li>Different nodes in a network(Virtual machines are used the the demo)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4><strong id=\"t5\">5. Always On Availability<\/strong><\/h4>\n<p>This is a new feature in SQL Server 2016 and provides a high availability feature for mission critical databases. This relates to the Database Clustering. However, in this demo for this part we would set up a network with three nodes:<\/p>\n<ul>\n<li><strong>DC Server<\/strong> &#8211; this a Windows 2019 Server configured as a domain controller<\/li>\n<li><strong>Server 2<\/strong> &#8211; this is the primary node of the SQL Always On Availability group<\/li>\n<li><strong>Server 3<\/strong> &#8211; the secondary node of the SQL Server Always On Availability group<\/li>\n<\/ul>\n<p>You can find Always On Availability in Management studio as shown in the figure below<\/p>\n<figure id=\"attachment_356\" aria-describedby=\"caption-attachment-356\" style=\"width: 317px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.42.48.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-356\" src=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.42.48.png?resize=317%2C337&#038;ssl=1\" alt=\"Always On High Availability in Managment Studio\" width=\"317\" height=\"337\" srcset=\"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.42.48.png?w=317&amp;ssl=1 317w, https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.42.48.png?resize=282%2C300&amp;ssl=1 282w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><figcaption id=\"caption-attachment-356\" class=\"wp-caption-text\">Always On High Availability in Managment Studio<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Now we have given an overview of the 5 High Availability approaches to SQL Server. You can now look at the related sections to learn how to perform the step by step configuration for each approach.<\/p>\n<p><!-- ktg-faq-schema --><br \/>\n<script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"What is high availability in SQL Server?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"High availability keeps databases online during hardware or software failures using features like failover clustering, Always On availability groups, and mirroring.\"}},{\"@type\":\"Question\",\"name\":\"What is the difference between failover clustering and Always On?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Failover clustering protects the entire instance at the OS level. Always On availability groups replicate databases with readable secondaries and flexible failover.\"}},{\"@type\":\"Question\",\"name\":\"Which SQL Server editions support Always On?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Always On availability groups require SQL Server Enterprise edition. Developer edition includes Enterprise features for non-production learning.\"}}]}<\/script><\/p>\n<p><!-- ktg-series-nav --><\/p>\n<nav class=\"ktg-series-nav\" aria-label=\"SQL Server tutorial series\">\n<p><strong>Previous:<\/strong> <a href=\"https:\/\/kindsonthegenius.com\/mssql\/t-sql-tutorial-for-beginners-select-joins-aggregates\/\">T-SQL Tutorial for Beginners: SELECT, JOINs, and Aggregates (2026)<\/a><\/p>\n<p><strong>Next:<\/strong> <a href=\"https:\/\/kindsonthegenius.com\/mssql\/how-to-configure-failover-cluster-in-sql-server-2019-step-by-step\/\">How to Configure Failover Cluster in SQL Server 2019 &#8211; Step by Step<\/a><\/p>\n<\/nav>\n<p><!-- ktg-alkademy-cta --><\/p>\n<div class=\"ktg-alkademy-cta\" style=\"margin:2em 0;padding:1.25em;border-left:4px solid #2563eb;background:#f8fafc;\">\n<p><strong>Want live SQL Server and BI classes?<\/strong> Join <a href=\"https:\/\/www.alkademy.com\/courses\" target=\"_blank\" rel=\"noopener noreferrer\">Alkademy<\/a> for instructor-led database administration and business intelligence courses.<\/p>\n<\/div>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Updated July 4, 2026: Reviewed for accuracy; notes added for SQL Server 2022\/2025 where applicable. High Availability(HA) describe methods used to ensure that the database &hellip; <!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[23],"tags":[27,25,24,28,26],"class_list":["post-350","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server","tag-clustering","tag-database-mirroring","tag-high-availability","tag-replication","tag-transaction-log-shipping"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MS SQL Server &#8211; High Availability | SQL Server Tutorial<\/title>\n<meta name=\"description\" content=\"SQL Server high availability overview \u2014 clustering, mirroring, log shipping, and Always On availability groups compared. Step-by-step SQL Server guide.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS SQL Server &#8211; High Availability | SQL Server Tutorial\" \/>\n<meta property=\"og:description\" content=\"SQL Server high availability overview \u2014 clustering, mirroring, log shipping, and Always On availability groups compared. Step-by-step SQL Server guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/\" \/>\n<meta property=\"og:site_name\" content=\"MS SQL Tutorial\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-01T09:46:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-04T21:50:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png\" \/>\n<meta name=\"author\" content=\"kindsonthegenius\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"kindsonthegenius\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/\"},\"author\":{\"name\":\"kindsonthegenius\",\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/#\\\/schema\\\/person\\\/85465e44cc819eb27309b70855fc2e27\"},\"headline\":\"MS SQL Server &#8211; High Availability\",\"datePublished\":\"2020-10-01T09:46:09+00:00\",\"dateModified\":\"2026-07-04T21:50:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/\"},\"wordCount\":654,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Screenshot-2020-10-01-at-11.34.32.png\",\"keywords\":[\"Clustering\",\"Database Mirroring\",\"High Availability\",\"Replication\",\"Transaction Log Shipping\"],\"articleSection\":[\"MS SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/\",\"url\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/\",\"name\":\"MS SQL Server &#8211; High Availability | SQL Server Tutorial\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Screenshot-2020-10-01-at-11.34.32.png\",\"datePublished\":\"2020-10-01T09:46:09+00:00\",\"dateModified\":\"2026-07-04T21:50:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/#\\\/schema\\\/person\\\/85465e44cc819eb27309b70855fc2e27\"},\"description\":\"SQL Server high availability overview \u2014 clustering, mirroring, log shipping, and Always On availability groups compared. Step-by-step SQL Server guide.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/kindsonthegenius.com\\\/mssql\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Screenshot-2020-10-01-at-11.34.32.png?fit=534%2C347&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/kindsonthegenius.com\\\/mssql\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Screenshot-2020-10-01-at-11.34.32.png?fit=534%2C347&ssl=1\",\"width\":534,\"height\":347,\"caption\":\"Replication in MS SQL Server\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/ms-sql-server-high-availability\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MS SQL Server &#8211; High Availability\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/#website\",\"url\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/\",\"name\":\"MS SQL Tutorial\",\"description\":\"Beginner to Expert MS SQL Tutorials\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/#\\\/schema\\\/person\\\/85465e44cc819eb27309b70855fc2e27\",\"name\":\"kindsonthegenius\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9d710de456c3d85e5614c3a6992fa3d527425e2ab32b8bd5d85bfbaa235004b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9d710de456c3d85e5614c3a6992fa3d527425e2ab32b8bd5d85bfbaa235004b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9d710de456c3d85e5614c3a6992fa3d527425e2ab32b8bd5d85bfbaa235004b?s=96&d=mm&r=g\",\"caption\":\"kindsonthegenius\"},\"url\":\"https:\\\/\\\/kindsonthegenius.com\\\/mssql\\\/author\\\/kindsonthegenius-3\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MS SQL Server &#8211; High Availability | SQL Server Tutorial","description":"SQL Server high availability overview \u2014 clustering, mirroring, log shipping, and Always On availability groups compared. Step-by-step SQL Server guide.","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:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/","og_locale":"en_US","og_type":"article","og_title":"MS SQL Server &#8211; High Availability | SQL Server Tutorial","og_description":"SQL Server high availability overview \u2014 clustering, mirroring, log shipping, and Always On availability groups compared. Step-by-step SQL Server guide.","og_url":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/","og_site_name":"MS SQL Tutorial","article_published_time":"2020-10-01T09:46:09+00:00","article_modified_time":"2026-07-04T21:50:20+00:00","og_image":[{"url":"https:\/\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png","type":"","width":"","height":""}],"author":"kindsonthegenius","twitter_card":"summary_large_image","twitter_misc":{"Written by":"kindsonthegenius","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#article","isPartOf":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/"},"author":{"name":"kindsonthegenius","@id":"https:\/\/kindsonthegenius.com\/mssql\/#\/schema\/person\/85465e44cc819eb27309b70855fc2e27"},"headline":"MS SQL Server &#8211; High Availability","datePublished":"2020-10-01T09:46:09+00:00","dateModified":"2026-07-04T21:50:20+00:00","mainEntityOfPage":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/"},"wordCount":654,"commentCount":0,"image":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#primaryimage"},"thumbnailUrl":"https:\/\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png","keywords":["Clustering","Database Mirroring","High Availability","Replication","Transaction Log Shipping"],"articleSection":["MS SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/","url":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/","name":"MS SQL Server &#8211; High Availability | SQL Server Tutorial","isPartOf":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#primaryimage"},"image":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#primaryimage"},"thumbnailUrl":"https:\/\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png","datePublished":"2020-10-01T09:46:09+00:00","dateModified":"2026-07-04T21:50:20+00:00","author":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/#\/schema\/person\/85465e44cc819eb27309b70855fc2e27"},"description":"SQL Server high availability overview \u2014 clustering, mirroring, log shipping, and Always On availability groups compared. Step-by-step SQL Server guide.","breadcrumb":{"@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#primaryimage","url":"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png?fit=534%2C347&ssl=1","contentUrl":"https:\/\/i0.wp.com\/kindsonthegenius.com\/mssql\/wp-content\/uploads\/2020\/10\/Screenshot-2020-10-01-at-11.34.32.png?fit=534%2C347&ssl=1","width":534,"height":347,"caption":"Replication in MS SQL Server"},{"@type":"BreadcrumbList","@id":"https:\/\/kindsonthegenius.com\/mssql\/ms-sql-server-high-availability\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kindsonthegenius.com\/mssql\/"},{"@type":"ListItem","position":2,"name":"MS SQL Server &#8211; High Availability"}]},{"@type":"WebSite","@id":"https:\/\/kindsonthegenius.com\/mssql\/#website","url":"https:\/\/kindsonthegenius.com\/mssql\/","name":"MS SQL Tutorial","description":"Beginner to Expert MS SQL Tutorials","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kindsonthegenius.com\/mssql\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kindsonthegenius.com\/mssql\/#\/schema\/person\/85465e44cc819eb27309b70855fc2e27","name":"kindsonthegenius","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b9d710de456c3d85e5614c3a6992fa3d527425e2ab32b8bd5d85bfbaa235004b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b9d710de456c3d85e5614c3a6992fa3d527425e2ab32b8bd5d85bfbaa235004b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b9d710de456c3d85e5614c3a6992fa3d527425e2ab32b8bd5d85bfbaa235004b?s=96&d=mm&r=g","caption":"kindsonthegenius"},"url":"https:\/\/kindsonthegenius.com\/mssql\/author\/kindsonthegenius-3\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/comments?post=350"}],"version-history":[{"count":7,"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/350\/revisions"}],"predecessor-version":[{"id":528,"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/350\/revisions\/528"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/media?parent=350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/categories?post=350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/tags?post=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}