{"id":2355,"date":"2011-10-17T07:42:56","date_gmt":"2011-10-17T05:42:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/"},"modified":"2011-10-17T07:42:56","modified_gmt":"2011-10-17T05:42:56","slug":"sql-server-2012-denali-alwayson-high-availability-restore-is-blocked","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/","title":{"rendered":"SQL Server 2012 &#8216;Denali&#8217; : AlwaysOn High Availability &#8211; Restore is blocked"},"content":{"rendered":"<p>During our test to create a failover clustering with the new function &#8216;AlwaysOn High Availability&#8217;, we had a few difficulties to overcome like the databases restore on the secondary cluster node.<\/p>\n<p>In this article, we will explain how to avoid it before encountering the problem.<\/p>\n<h3>Environment<\/h3>\n<p>VMTESTSQL02 is an AD-DC (Active Directory &#8211; Domain Controller) server (It should not be confused with ACDC, the Hard Rock Group :roll:) with the domain TESTSQL.<br \/>\nVMTESTSHPT01 is a SQL Server &#8216;Denali&#8217; with AdventureWork and is the Primary Server for the Failover Clustering<br \/>\nVMTESTSQL03 is a SQL Server &#8216;Denali&#8217; without database and will be the Secondary Server for the Failover Clustering<\/p>\n<p>The Cluster VMTESTSQL is a Windows Cluster and not a SQL Server cluster.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/00-Denali-archi.png\" alt=\"00-Denali-archi\" width=\"645\" height=\"355\" \/><\/p>\n<h3>Installation<\/h3>\n<p>For the SQL Server installation, we install a new SQL Server in stand-alone mode.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/01-Denali-install.png\" alt=\"\" width=\"546\" height=\"232\" \/><\/p>\n<p>The most important for this article is the account name for the SQL Server Database Engine Services in the Server Configuration page within the installation.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/02-Denali-install.png\" alt=\"\" width=\"572\" height=\"445\" \/><\/p>\n<p>Note that by default the services are secured through their account.<br \/>\nThey are no needs to create Windows service accounts unlike with previous versions.<\/p>\n<h3>SQL Server Database Engine Service<\/h3>\n<p>If you open your Sql Server Configuration Manager, you can see that SQL Server Database Engine Services run with the account NT ServiceMSSQL$.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/03-Denali-Service.png\" alt=\"\" width=\"587\" height=\"117\" \/><\/p>\n<p>To create an AlwaysOn High Availability Group, you must enable it on the service property like this example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/04-Denali-Serviceproperty.png\" alt=\"\" width=\"690\" height=\"441\" \/><\/p>\n<h3>Logins Configuration<\/h3>\n<p>If you look in SSMS (Sql Server Management Studio), the Server Roles for the account NT ServiceMSSQL$, you can see that this account is sysadmin and have all right of the instance.<\/p>\n<p><img decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/05-Denali-ServerRole.png\" alt=\"\" \/><\/p>\n<h3><\/h3>\n<h3>Create a &#8216;AlwaysOn High Availability&#8217; Group<\/h3>\n<p>For the Step 2,3 and 4, it&#8217;s the same for the 2 &#8220;SQL Server 2012&#8221; Servers.<br \/>\nTo create the &#8216;Availability Group&#8217;, we launch the SSMS of VMTESTSHPT01 with the database AdventureWork.<\/p>\n<ul>\n<li>Step 1 : Choose Availability group name<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/06-Denali-AG.png\" alt=\"\" width=\"484\" height=\"446\" \/><\/p>\n<ul>\n<li>Step 2 : Select databases for the Availability Group<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/07-Denali-AG.png\" alt=\"\" width=\"488\" height=\"449\" \/><\/p>\n<ul>\n<li>Step 3 : Specify the Primary and the Secondary Server<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/08-Denali-AG.png\" alt=\"\" width=\"491\" height=\"453\" \/><\/p>\n<ul>\n<li>Step 4 : Create your Availability Group Listener<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/09-Denali-AG.png\" alt=\"\" width=\"497\" height=\"459\" \/><\/p>\n<ul>\n<li>Step 5 : Select a shared network location for the backup<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/10-Denali-AG.png\" alt=\"\" width=\"500\" height=\"460\" \/><\/p>\n<p>To make sure that we have the appropriated rights on this share, we shared it with read\/write rights for everyone.<\/p>\n<ul>\n<li>Step 6 : Test the validity of the configuration<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/11-Denali-AG.png\" alt=\"\" width=\"521\" height=\"481\" \/><\/p>\n<ul>\n<li>Step 7 : Verify the configuration<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/12-Denali-AG.png\" alt=\"\" width=\"530\" height=\"489\" \/><\/p>\n<p>Before you click on the Finish button, create the script from your Availabily Group.<br \/>\nThis is to play again your scenario or to create a template with sqlcmd variables.<\/p>\n<ul>\n<li>Step 8 : Creating the Availabily Group<\/li>\n<\/ul>\n<p>The last step is the creation itself. If you look the detail, you can see that the last step failed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/13-Denali-Error.png\" alt=\"\" width=\"590\" height=\"544\" \/><\/p>\n<p>Here are the errors details :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/14-Denali-Error.png\" alt=\"\" width=\"549\" height=\"218\" \/><\/p>\n<h3><\/h3>\n<h3>Verify the Services on the cluster<\/h3>\n<p>It&#8217;s running&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/16-Denali-severmanager.png\" alt=\"\" width=\"612\" height=\"374\" \/><\/p>\n<h3><\/h3>\n<h3>Verify the Secondary server<\/h3>\n<p>We can see that the database AdventureWorks stay in a restoring mode in the server VMTESTSQL03.<\/p>\n<p><img decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/15-Denali-sql03.png\" alt=\"\" \/><\/p>\n<h3>Why it doesn&#8217;t work ?<\/h3>\n<p>The account NT ServiceMSSQL$ is sysadmin but have not the right to restore a database from a shared directory.<br \/>\nThe first test is to grant the account with the role dbcreator. This is just to verify but it doesn&#8217;t work.<\/p>\n<p>The point is that for database mirroring, Domain service accounts is a prerequisite :<\/p>\n<p><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ff878487%28v=SQL.110%29.aspx\" target=\"_blank\">http:\/\/msdn.microsoft.com\/en-us\/library\/ff878487(v=SQL.110).aspx<\/a><\/p>\n<p>Finnally, we have change the account to a domain account for the 2 servers.<br \/>\nIf you don&#8217;t change it for both servers, you have the same problem.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/17-Denali-changeAccount.png\" alt=\"17-Denali-changeAccount\" width=\"671\" height=\"458\" \/><\/p>\n<p>Take care, this operation needs a restart of the service.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/18-Denali-changeAccount.png\" alt=\"\" width=\"675\" height=\"132\" \/><\/p>\n<p>Add the user in the instance with sysadmin server role:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/19-Denali-changeAccount.png\" alt=\"\" width=\"248\" height=\"221\" \/><\/p>\n<p>And finally, it&#8217;s magic,\u00a0 your failover is operational!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/191-Denali-changeAccount.png\" alt=\"\" width=\"555\" height=\"510\" \/><\/p>\n<p>You can see of the secondary server and the database is online.. That&#8217;s running:-D<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/192-Denali-changeAccount.png\" alt=\"\" width=\"292\" height=\"380\" \/><\/p>\n<h3><\/h3>\n<h3>sys.dm_server_services : A new DMV<\/h3>\n<p>Before concluding this article, here is a new dynamic management view introduced by SQL Server 11 CTP3 which returns property information associated with the SQL Server services like SQL Server, Full-Text, and SQL Server Agent services in the current instance of SQL Server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/20-Denali-dmv.png\" alt=\"\" width=\"641\" height=\"171\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>During our test to create a failover clustering with the new function &#8216;AlwaysOn High Availability&#8217;, we had a few difficulties to overcome like the restoring of databases of the secondary cluster node.<\/p>\n<p>In this article, we will just explain you how to avoid it before you encounter the problem.<\/p>\n","protected":false},"author":15,"featured_media":2356,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[42],"tags":[262,84,263,49,264,265,54],"class_list":["post-2355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-operating-systems","tag-analysis-services","tag-high-availability","tag-integration-services","tag-microsoft","tag-reporting-services","tag-sql-server-2008","tag-sql-server-2012"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2012 &#039;Denali&#039; : AlwaysOn High Availability - Restore is blocked - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"During our test to create a failover clustering with the new function &#039;AlwaysOn High Availability&#039;, we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you how to avoid it before you encounter the problem.\" \/>\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.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012 &#039;Denali&#039; : AlwaysOn High Availability - Restore is blocked\" \/>\n<meta property=\"og:description\" content=\"During our test to create a failover clustering with the new function &#039;AlwaysOn High Availability&#039;, we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you how to avoid it before you encounter the problem.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-17T05:42:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/00-Denali-archi.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1508\" \/>\n\t<meta property=\"og:image:height\" content=\"832\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\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:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server 2012 &#8216;Denali&#8217; : AlwaysOn High Availability &#8211; Restore is blocked\",\"datePublished\":\"2011-10-17T05:42:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/\"},\"wordCount\":653,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/00-Denali-archi.png\",\"keywords\":[\"Analysis services\",\"High Availability\",\"Integration services\",\"Microsoft\",\"Reporting services\",\"SQL Server 2008\",\"SQL Server 2012\"],\"articleSection\":[\"Operating System\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/\",\"name\":\"SQL Server 2012 'Denali' : AlwaysOn High Availability - Restore is blocked - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/00-Denali-archi.png\",\"datePublished\":\"2011-10-17T05:42:56+00:00\",\"description\":\"During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you how to avoid it before you encounter the problem.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/00-Denali-archi.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/00-Denali-archi.png\",\"width\":1508,\"height\":832},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012 &#8216;Denali&#8217; : AlwaysOn High Availability &#8211; Restore is blocked\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012 'Denali' : AlwaysOn High Availability - Restore is blocked - dbi services | Blog","description":"During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you how to avoid it before you encounter the problem.","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.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012 'Denali' : AlwaysOn High Availability - Restore is blocked","og_description":"During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you how to avoid it before you encounter the problem.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2011-10-17T05:42:56+00:00","og_image":[{"width":1508,"height":832,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/00-Denali-archi.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server 2012 &#8216;Denali&#8217; : AlwaysOn High Availability &#8211; Restore is blocked","datePublished":"2011-10-17T05:42:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/"},"wordCount":653,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/00-Denali-archi.png","keywords":["Analysis services","High Availability","Integration services","Microsoft","Reporting services","SQL Server 2008","SQL Server 2012"],"articleSection":["Operating System"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/","name":"SQL Server 2012 'Denali' : AlwaysOn High Availability - Restore is blocked - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/00-Denali-archi.png","datePublished":"2011-10-17T05:42:56+00:00","description":"During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you how to avoid it before you encounter the problem.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/00-Denali-archi.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/00-Denali-archi.png","width":1508,"height":832},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-denali-alwayson-high-availability-restore-is-blocked\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012 &#8216;Denali&#8217; : AlwaysOn High Availability &#8211; Restore is blocked"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2355"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2355\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2356"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}