{"id":16650,"date":"2014-07-03T13:31:01","date_gmt":"2014-07-03T13:31:01","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=16650"},"modified":"2014-07-03T13:34:23","modified_gmt":"2014-07-03T13:34:23","slug":"sql-server-now-requires-sa-for-a-cold-replica","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=16650","title":{"rendered":"SQL Server Now Requires SA For A Cold Replica"},"content":{"rendered":"<p>When you replicate a virtual machine from site A to site B then typically the replica VM in site B is powered down. Note that I haven\u2019t specified a hypervisor or replication method, so this article applies to <a href=\"https:\/\/aidanfinn.com\/?tag=hyper-v\" target=\"_blank\">Hyper-V<\/a> and vSphere, and not just to Hyper-V Replica.<\/p>\n<p>In the past, if you ran SQL Server in a VM in a production site, you could replicate that VM to a secondary site. If the replica VM was powered down, i.e. cold, then you were granted a free license for that cold VM. This has changed with the release of SQL Server 2014, as covered by this <a href=\"http:\/\/microsoftlicensereview.com\/2014\/06\/22\/sql-2014-licensing-update\/\" target=\"_blank\">post<\/a>. Now you must have Software Assurance (SA) to cover the cold VM\u2019s license for SQL Server.<\/p>\n<p>This brings SQL Server in line with <a href=\"https:\/\/aidanfinn.com\/?s=Windows+Server\" target=\"_blank\">Windows Server<\/a>\u2019s SA offsite cold replica benefit.<\/p>\n<p>There are restrictions on failover in the secondary site:<\/p>\n<ul>\n<li>You can perform a brief test failover (lasting 1 week) once every 90 days.<\/li>\n<li>The production system in the primary site must be powered off to legally perform a failover.<\/li>\n<li>You can power up the secondary site VM for a \u201cbrief time\u201d during the disaster while the production system is running in the primary site.<\/li>\n<\/ul>\n<div class=\"wlWriterEditableSmartContent\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:7b29623f-4d14-4640-9ae6-ca754b59dee7\" style=\"float: none; margin: 0px; display: inline; padding: 0px;\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/Windows+Server+2012\" rel=\"tag\">Windows Server 2012<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Windows+Server+2012+R2\" rel=\"tag\">Windows Server 2012 R2<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Hyper-V\" rel=\"tag\">Hyper-V<\/a>,<a href=\"http:\/\/technorati.com\/tags\/DR\" rel=\"tag\">DR<\/a>,<a href=\"http:\/\/technorati.com\/tags\/SQL\" rel=\"tag\">SQL<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Licensing\" rel=\"tag\">Licensing<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>When you replicate a virtual machine from site A to site B then typically the replica VM in site B is powered down. Note that I haven\u2019t specified a hypervisor or replication method, so this article applies to Hyper-V and vSphere, and not just to Hyper-V Replica. In the past, if you ran SQL Server &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=16650\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL Server Now Requires SA For A Cold Replica&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_wpcom_ai_launchpad_first_post":false,"footnotes":""},"categories":[20],"tags":[61,181,183,192,118,120],"class_list":["post-16650","post","type-post","status-publish","format-standard","hentry","category-hyper-v","tag-dr","tag-hyper-v","tag-licensing","tag-sql","tag-windows-server-2012","tag-windows-server-2012-r2"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site&#039;s cold replicas of SQL Server VMs.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"AFinn\"\/>\n\t<meta name=\"google-site-verification\" content=\"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aidanfinn.com\/?p=16650\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_GB\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro\" \/>\n\t\t<meta property=\"og:description\" content=\"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site&#039;s cold replicas of SQL Server VMs.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aidanfinn.com\/?p=16650\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2014-07-03T13:31:01+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2014-07-03T13:34:23+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@joe_elway\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site&#039;s cold replicas of SQL Server VMs.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@joe_elway\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#article\",\"name\":\"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro\",\"headline\":\"SQL Server Now Requires SA For A Cold Replica\",\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"},\"datePublished\":\"2014-07-03T13:31:01+01:00\",\"dateModified\":\"2014-07-03T13:34:23+01:00\",\"inLanguage\":\"en-GB\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#webpage\"},\"articleSection\":\"Hyper-V, DR, Hyper-V, Licensing, SQL, Windows Server 2012, Windows Server 2012 R2\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=20#listItem\",\"name\":\"Hyper-V\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=20#listItem\",\"position\":2,\"name\":\"Hyper-V\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=20\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#listItem\",\"name\":\"SQL Server Now Requires SA For A Cold Replica\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#listItem\",\"position\":3,\"name\":\"SQL Server Now Requires SA For A Cold Replica\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=20#listItem\",\"name\":\"Hyper-V\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#webpage\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650\",\"name\":\"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro\",\"description\":\"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site's cold replicas of SQL Server VMs.\",\"inLanguage\":\"en-GB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=16650#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"datePublished\":\"2014-07-03T13:31:01+01:00\",\"dateModified\":\"2014-07-03T13:34:23+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"name\":\"Aidan Finn, IT Pro\",\"description\":\"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\",\"inLanguage\":\"en-GB\",\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro","description":"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site's cold replicas of SQL Server VMs.","canonical_url":"https:\/\/aidanfinn.com\/?p=16650","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aidanfinn.com\/?p=16650#article","name":"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro","headline":"SQL Server Now Requires SA For A Cold Replica","author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"publisher":{"@id":"https:\/\/aidanfinn.com\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=16650#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"},"datePublished":"2014-07-03T13:31:01+01:00","dateModified":"2014-07-03T13:34:23+01:00","inLanguage":"en-GB","mainEntityOfPage":{"@id":"https:\/\/aidanfinn.com\/?p=16650#webpage"},"isPartOf":{"@id":"https:\/\/aidanfinn.com\/?p=16650#webpage"},"articleSection":"Hyper-V, DR, Hyper-V, Licensing, SQL, Windows Server 2012, Windows Server 2012 R2"},{"@type":"BreadcrumbList","@id":"https:\/\/aidanfinn.com\/?p=16650#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/#listItem","position":1,"name":"Home","item":"https:\/\/aidanfinn.com\/","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=20#listItem","name":"Hyper-V"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=20#listItem","position":2,"name":"Hyper-V","item":"https:\/\/aidanfinn.com\/?cat=20","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=16650#listItem","name":"SQL Server Now Requires SA For A Cold Replica"},"previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=16650#listItem","position":3,"name":"SQL Server Now Requires SA For A Cold Replica","previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=20#listItem","name":"Hyper-V"}}]},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/#person","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=16650#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/?author=1#author","url":"https:\/\/aidanfinn.com\/?author=1","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=16650#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"WebPage","@id":"https:\/\/aidanfinn.com\/?p=16650#webpage","url":"https:\/\/aidanfinn.com\/?p=16650","name":"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro","description":"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site's cold replicas of SQL Server VMs.","inLanguage":"en-GB","isPartOf":{"@id":"https:\/\/aidanfinn.com\/#website"},"breadcrumb":{"@id":"https:\/\/aidanfinn.com\/?p=16650#breadcrumblist"},"author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"creator":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"datePublished":"2014-07-03T13:31:01+01:00","dateModified":"2014-07-03T13:34:23+01:00"},{"@type":"WebSite","@id":"https:\/\/aidanfinn.com\/#website","url":"https:\/\/aidanfinn.com\/","name":"Aidan Finn, IT Pro","description":"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","inLanguage":"en-GB","publisher":{"@id":"https:\/\/aidanfinn.com\/#person"}}]},"og:locale":"en_GB","og:site_name":"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","og:type":"article","og:title":"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro","og:description":"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site's cold replicas of SQL Server VMs.","og:url":"https:\/\/aidanfinn.com\/?p=16650","article:published_time":"2014-07-03T13:31:01+00:00","article:modified_time":"2014-07-03T13:34:23+00:00","twitter:card":"summary","twitter:site":"@joe_elway","twitter:title":"SQL Server Now Requires SA For A Cold DR Replica | Aidan Finn, IT Pro","twitter:description":"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site's cold replicas of SQL Server VMs.","twitter:creator":"@joe_elway"},"aioseo_meta_data":{"post_id":"16650","title":"SQL Server Now Requires SA For A Cold DR Replica | #site_title","description":"Since the release of SQL Server 2014, you need Software Assurance on your production SQL Server installations to license your DR site's cold replicas of SQL Server VMs.","keywords":[{"label":"Windows Server 2012","value":"Windows Server 2012"},{"label":"Windows Server 2012 R2","value":"Windows Server 2012 R2"},{"label":"Hyper-V","value":"Hyper-V"},{"label":"DR","value":"DR"},{"label":"SQL","value":"SQL"},{"label":"Licensing","value":"Licensing"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 03:53:21","updated":"2025-06-04 16:27:51","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/?cat=20\" title=\"Hyper-V\">Hyper-V<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSQL Server Now Requires SA For A Cold Replica\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/aidanfinn.com\/"},{"label":"Hyper-V","link":"https:\/\/aidanfinn.com\/?cat=20"},{"label":"SQL Server Now Requires SA For A Cold Replica","link":"https:\/\/aidanfinn.com\/?p=16650"}],"amp_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/16650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16650"}],"version-history":[{"count":3,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/16650\/revisions"}],"predecessor-version":[{"id":16653,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/16650\/revisions\/16653"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}