{"id":14296,"date":"2019-12-23T07:24:35","date_gmt":"2019-12-23T07:24:35","guid":{"rendered":"https:\/\/dbtut.com\/?p=14296"},"modified":"2019-12-23T07:28:58","modified_gmt":"2019-12-23T07:28:58","slug":"resumable-indexes-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/","title":{"rendered":"Resumable Indexes in SQL Server"},"content":{"rendered":"<h2>What is Resumable Index?<\/h2>\n<p>When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In such cases, you must mark the index as RESUMABLE = ON in order for the rebuild process to resume after it fails.<\/p>\n<h3>Create a Resumable Index<\/h3>\n<p>You can create a resumable index with the following script.<\/p>\n<pre class=\"lang:default decode:true\">CREATE NONCLUSTERED INDEX IndexName ON schemaname.tablename(Indexcolum) WITH (Online = ON,RESUMABLE = ON);<\/pre>\n<h3>Alter an Index With Resumable<\/h3>\n<p>You can alter the index as resumable with the following script.<\/p>\n<pre class=\"lang:default decode:true\">ALTER INDEX IndexName ON schemaname.tablename REBUILD WITH (ONLINE=ON,RESUMABLE=ON);<\/pre>\n<p>If you do not add &#8220;ONLINE = ON&#8221; to the script, you will receive an error as follows.<\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 11438, Level 15, State 1, Line 3<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>The RESUMABLE option cannot be set to &#8216;ON&#8217; when the ONLINE option is set to &#8216;OFF&#8217;.<\/em><\/span><\/p>\n<h3>Pause Index Rebuild Process<\/h3>\n<p>Below is the code that pauses the index rebuild process.<\/p>\n<pre class=\"lang:default decode:true\">ALTER INDEX IndexName ON schemaname.tablename PAUSE;<\/pre>\n<h3>Resume Paused or Failed Index Rebuild Process<\/h3>\n<p>Below is the query that you can resume a paused Index Rebuild process.<\/p>\n<p>Suppose you forgot to start Index rebuild with maxdop. You can increase the parallelism level of the query by pausing the Index Rebuild operation and changing the maxdop level while resume.<\/p>\n<pre class=\"lang:default decode:true\">ALTER INDEX IndexName ON schemaname.tablename RESUME WITH (MAXDOP=4)<\/pre>\n<h3>Resumable Index Options<\/h3>\n<p>In the following query, we resume the Index with different options. For other options in the query, I recommend reading &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/10\/01\/how-to-manage-online-index-rebuild-and-partition-switch-processes-with-wait_at_low_priority\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Manage Online Index Rebuild and Partition Switch Processes With WAIT_AT_LOW_PRIORITY<\/a>&#8220;.<\/p>\n<pre class=\"lang:default decode:true\">ALTER INDEX IndexName ON schemaname.tablename \nRESUME WITH (MAXDOP=2, MAX_DURATION= 240 MINUTES, WAIT_AT_LOW_PRIORITY (MAX_DURATION=10, ABORT_AFTER_WAIT=BLOCKERS)) ;\n<\/pre>\n<h3>Abort Index Rebuild Process<\/h3>\n<p>We can abort the index rebuild process which is pause or running, with the help of the following query.<\/p>\n<pre class=\"lang:default decode:true\">ALTER INDEX IndexName ON schemaname.tablename ABORT;<\/pre>\n<h2>Resumable Index Limitations<\/h2>\n<ul>\n<li>SORT_IN_TEMPDB = ON is not supported in RESUMABLE indexes.<\/li>\n<li>We cannot rebuild disabled indexes as RESUMABLE.<\/li>\n<\/ul>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14296\" class=\"pvc_stats all  \" data-element-id=\"14296\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In such cases, you must mark the index as RESUMABLE = ON in order for the rebuild process to resume after it fails. Create a Resumable Index You can create a &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14296\" class=\"pvc_stats all  \" data-element-id=\"14296\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":14299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[6758,6749,6862,6768,6751,6769,6754,6753,5690,6748,6752,6763,6762,6760,6759,6765,6776,6764,6761,6771,6772,6766,6767,6770,6773,6756,6757,6755,6750,6775,6774,6747,6746],"class_list":["post-14296","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-abort-index-rebuild-process","tag-alter-an-index-as-resumable","tag-alter-an-index-with-resumable","tag-alter-index-resumable","tag-create-a-resumable-index","tag-index_resumable_operations","tag-online-rebuild-index-as-resumable","tag-online-rebuild-index-with-resumable","tag-oracle-rebuild-index-all-partitions","tag-pause-index-rebuild-process","tag-rebuild-index-with-resumable","tag-resumable-index","tag-resumable-index-in-sql-server","tag-resumable-index-limitations","tag-resumable-index-options","tag-resumable-index-rebuild","tag-resumable-index-rebuild-sql-server","tag-resumable-indexes","tag-resumable-indexes-in-sql-server","tag-resumable-online-index-create","tag-resumable-online-index-create-sql-server","tag-resumable-online-index-rebuild","tag-resumable-online-index-rebuild-in-sql-server","tag-resumable-online-index-rebuild-in-sql-server-2017","tag-resumable-online-index-rebuilds","tag-resume-failed-index-rebuild-process","tag-resume-paused-index-rebuild-process","tag-resume-paused-or-failed-index-rebuild-process","tag-set-an-index-as-resumable","tag-sql-server-2017-resumable-online-index-rebuild","tag-sql-server-resumable-online-index-rebuilds","tag-the-resumable-option-cannot-be-set-to-on-when-the-online-option-is-set-to-off","tag-what-is-resumable-index"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":398,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Resumable Indexes in SQL Server - Database Tutorials<\/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:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resumable Indexes in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In such cases, you must mark the index as RESUMABLE = ON in order for the rebuild process to resume after it fails. Create a Resumable Index You can create a &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-23T07:24:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-23T07:28:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png\" \/>\n\t<meta property=\"og:image:width\" content=\"529\" \/>\n\t<meta property=\"og:image:height\" content=\"354\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Resumable Indexes in SQL Server\",\"datePublished\":\"2019-12-23T07:24:35+00:00\",\"dateModified\":\"2019-12-23T07:28:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/\"},\"wordCount\":267,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png\",\"keywords\":[\"Abort Index Rebuild Process\",\"Alter an Index As Resumable\",\"Alter an Index With Resumable\",\"alter index resumable\",\"Create a Resumable Index\",\"index_resumable_operations\",\"Online Rebuild Index as resumable\",\"Online Rebuild Index with resumable\",\"oracle rebuild index all partitions\",\"Pause Index Rebuild Process\",\"Rebuild Index with resumable\",\"Resumable Index\",\"Resumable Index in SQL Server\",\"Resumable Index Limitations\",\"Resumable Index Options\",\"resumable index rebuild\",\"resumable index rebuild sql server\",\"Resumable Indexes\",\"Resumable Indexes in SQL Server\",\"resumable online index create\",\"resumable online index create sql server\",\"resumable online index rebuild\",\"resumable online index rebuild in sql server\",\"resumable online index rebuild in sql server 2017\",\"resumable online index rebuilds\",\"Resume Failed Index Rebuild Process\",\"Resume Paused Index Rebuild Process\",\"Resume Paused or Failed Index Rebuild Process\",\"Set an Index As Resumable\",\"sql server 2017 resumable online index rebuild\",\"sql server resumable online index rebuilds\",\"The RESUMABLE option cannot be set to 'ON' when the ONLINE option is set to 'OFF'.\",\"What is Resumable Index\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/\",\"name\":\"Resumable Indexes in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png\",\"datePublished\":\"2019-12-23T07:24:35+00:00\",\"dateModified\":\"2019-12-23T07:28:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png\",\"width\":529,\"height\":354},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resumable Indexes in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Resumable Indexes in SQL Server - Database Tutorials","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:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Resumable Indexes in SQL Server - Database Tutorials","og_description":"What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In such cases, you must mark the index as RESUMABLE = ON in order for the rebuild process to resume after it fails. Create a Resumable Index You can create a &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-23T07:24:35+00:00","article_modified_time":"2019-12-23T07:28:58+00:00","og_image":[{"width":529,"height":354,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Resumable Indexes in SQL Server","datePublished":"2019-12-23T07:24:35+00:00","dateModified":"2019-12-23T07:28:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/"},"wordCount":267,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png","keywords":["Abort Index Rebuild Process","Alter an Index As Resumable","Alter an Index With Resumable","alter index resumable","Create a Resumable Index","index_resumable_operations","Online Rebuild Index as resumable","Online Rebuild Index with resumable","oracle rebuild index all partitions","Pause Index Rebuild Process","Rebuild Index with resumable","Resumable Index","Resumable Index in SQL Server","Resumable Index Limitations","Resumable Index Options","resumable index rebuild","resumable index rebuild sql server","Resumable Indexes","Resumable Indexes in SQL Server","resumable online index create","resumable online index create sql server","resumable online index rebuild","resumable online index rebuild in sql server","resumable online index rebuild in sql server 2017","resumable online index rebuilds","Resume Failed Index Rebuild Process","Resume Paused Index Rebuild Process","Resume Paused or Failed Index Rebuild Process","Set an Index As Resumable","sql server 2017 resumable online index rebuild","sql server resumable online index rebuilds","The RESUMABLE option cannot be set to 'ON' when the ONLINE option is set to 'OFF'.","What is Resumable Index"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/","name":"Resumable Indexes in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png","datePublished":"2019-12-23T07:24:35+00:00","dateModified":"2019-12-23T07:28:58+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-12.png","width":529,"height":354},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/23\/resumable-indexes-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Resumable Indexes in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14296"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14296\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14299"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}