{"id":49323,"date":"2023-03-28T08:00:00","date_gmt":"2023-03-28T15:00:00","guid":{"rendered":""},"modified":"2024-01-31T13:37:09","modified_gmt":"2024-01-31T21:37:09","slug":"accelerated-database-recovery-enhancements-in-sql-server-2022","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/","title":{"rendered":"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0"},"content":{"rendered":"\n<p><em>Part of the&nbsp;<\/em><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/tag\/sql-server-2022-blogging-series\" target=\"_blank\" rel=\"noreferrer noopener\"><em>SQL Server 2022 blog series<\/em><\/a>.&nbsp;<\/p>\n\n\n\n<p>We are excited to share that there are several Accelerated Database Recovery (ADR) enhancements in <a href=\"https:\/\/www.microsoft.com\/sql-server\/sql-server-2022\">SQL Server 2022<\/a> that further improve the overall availability and scalability of the database, primarily around persistent version store (PVS) cleanup and management.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"overview-of-accelerated-database-recovery-adr\">Overview of Accelerated Database Recovery (ADR)&nbsp;<\/h2>\n\n\n\n<p>ADR improves database availability, especially in the presence of long running transactions, by redesigning the SQL database engine recovery process. ADR is introduced in SQL Server 2019 (15.x) and improved in SQL Server 2022 (16.x).&nbsp;<\/p>\n\n\n\n<p>ADR is also available for databases in Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse SQL. ADR is enabled by default in SQL Database and SQL Managed Instance and cannot be disabled.&nbsp;<\/p>\n\n\n\n<p>The primary benefits of Accelerated Database Recovery (ADR) are<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"fast-and-consistent-database-recovery\">Fast and consistent database recovery&nbsp;<\/h3>\n\n\n\n<p>With ADR, long running transactions do not impact the overall recovery time, enabling fast and consistent database recovery irrespective of the number of active transactions in the system or their sizes.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"instantaneous-transaction-rollback\">Instantaneous transaction rollback&nbsp;<\/h3>\n\n\n\n<p>With ADR, transaction rollback is instantaneous, irrespective of the time that the transaction has been active or the number of updates that has performed.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aggressive-log-truncation\">Aggressive log truncation&nbsp;<\/h3>\n\n\n\n<p>With ADR, the transaction log is aggressively truncated, even in the presence of active long running transactions, which prevents it from growing out of control.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>ADR completely redesigns the database engine recovery process.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Make it constant time and instant by avoiding having to scan the log from and to the beginning of the oldest active transaction. With ADR, the transaction log is only processed from the last successful checkpoint (or oldest dirty page log sequence number (LSN)). As a result, recovery time is not impacted by long running transactions.<\/li>\n\n\n\n<li>Minimize the required transaction log space since there is no longer a need to process the log for the whole transaction. As a result, the transaction log can be truncated aggressively as checkpoints and backups occur.<\/li>\n<\/ul>\n\n\n\n<p>At a high level, ADR achieves fast database recovery by versioning all physical database modifications and only undoing logical operations, which are limited and can be undone almost instantly. Any transactions that were active at the time of a crash are marked as aborted and, therefore, any versions generated by these transactions can be ignored by concurrent user queries.<\/p>\n<\/div>\n\n\n\n<p><strong>Note<\/strong>: For more details about ADR, please visit <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/accelerated-database-recovery-concepts?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">this page<\/a>: and this <a href=\"https:\/\/www.youtube.com\/watch?v=N5lU7695PG8\" target=\"_blank\" rel=\"noreferrer noopener\">video<\/a> for a high-level overview of ADR and its components.<\/p>\n\n\n<div class=\"wp-block-msxcm-cta-block\" data-moray data-bi-an=\"CTA Block\">\n\t<div class=\"card d-block mx-ng mx-md-0\">\n\t\t<div class=\"row no-gutters material-color-brand-light bg-fabric-white\">\n\n\t\t\t\t\t\t\t<div class=\"col-md-4\">\n\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"850\" height=\"566\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/img.png\" class=\"card-img img-object-cover\" alt=\"a man sitting at a table using a laptop\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/img.webp 850w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/img-300x200.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/img-768x511.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/img-800x533.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/img-400x266.webp 400w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>\t\t\t\t<\/div>\n\t\t\t\n\t\t\t<div class=\"d-flex col-md\">\n\t\t\t\t<div class=\"card-body align-self-center p-4 p-md-5\">\n\t\t\t\t\t\n\t\t\t\t\t<h2>SQL Server 2022<\/h2>\n\n\t\t\t\t\t<div class=\"mb-3\">\n\t\t\t\t\t\t<p>Learn about the new features on security, platform, management, and more.<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"link-group\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-2022?view=sql-server-ver16\" class=\"btn btn-link text-decoration-none p-0\" target=\"_blank\">\n\t\t\t\t\t\t\t\t<span>Read what&#039;s new<\/span>\n\t\t\t\t\t\t\t\t<span class=\"glyph-append glyph-append-chevron-right glyph-append-xsmall\"><\/span>\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"new-adr-improvements-in-sql-server-2022\">New ADR improvements in SQL Server 2022 <\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"multi-threaded-version-cleanup\">Multi-threaded version cleanup<\/h3>\n\n\n\n<p>In SQL Server 2019 (15.x), the ADR cleanup process is single threaded within a SQL Server instance. Beginning with SQL Server 2022 (16.x), this process uses multi-threaded version cleanup (MTVC), that allows multiple databases under the same SQL Server instance to be cleaned in parallel. <\/p>\n\n\n\n<p>MTVC is enabled by default in SQL Server 2022 and uses one thread per SQL instance. To adjust the number of threads for version cleanup, set ADR Cleaner Thread Count with <code>sp_configure<\/code>. <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nUSE master;\nGO\n-- Enable show advanced option to see ADR Cleaner Thread Count\nEXEC sp_configure 'show advanced option', '1';\n-- List all advanced options\nRECONFIGURE;\nEXEC sp_configure;\u00a0\n-- The following example sets the ADR Cleaner Thread Count to 4\nEXEC sp_configure 'ADR Cleaner Thread Count', '4';\nRECONFIGURE WITH OVERRIDE;\u00a0\n-- Run RECONFIGURE to verify the number of threads allocated to ADR Version Cleaner.\nRECONFIGURE;\nEXEC sp_configure;\n<\/pre><\/div>\n\n\n<p>In the above example, if you configure the ADR Cleaner Count to be four on a sql instance with two databases, the ADR cleaner will allocate only one thread per database, leaving the remaining two threads idle.<\/p>\n\n\n\n<p><strong>Note<\/strong>: The maximum number of ADR Cleaner threads is capped at the number of cores used by the SQL Server instance. For example, if you are running SQL Server on an eight core machine, the maximum number of ADR cleaner threads that the engine can use will be eight, even if the value in the <code>sp_configure<\/code> is set to a greater value. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"user-transaction-cleanup\">User transaction cleanup<\/h3>\n\n\n\n<p>This improvement allows user transactions to run cleanup on pages that could not be addressed by the regular cleanup process due to lock conflicts. This helps ensure that the ADR cleanup process works more efficiently.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"reducing-memory-footprint-for-pvs-page-tracker\">Reducing memory footprint for PVS page tracker<\/h3>\n\n\n\n<p>This improvement tracks persisted version store (PVS) pages at the extent level, in order to reduce the memory footprint needed to maintain versioned pages.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"accelerated-data-recovery-cleaner-improvements\">Accelerated Data Recovery cleaner improvements<\/h3>\n\n\n\n<p>ADR cleaner has improved version cleanup efficiencies to improve how SQL Server tracks and records aborted versions of a page leading to improvements in memory and capacity.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"transaction-level-persisted-version-store\">Transaction-level persisted version store<\/h3>\n\n\n\n<p>This improvement allows ADR to clean up versions belonging to committed transactions independent of whether there are aborted transactions in the system. With this improvement PVS pages can be deallocated, even if the cleanup cannot complete a successful sweep to trim the aborted transaction map.<\/p>\n\n\n\n<p>The result of this improvement is reduced PVS growth even if ADR cleanup is slow or fails.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"new-extended-event\">New extended event<\/h3>\n\n\n\n<p>A new extended event,&nbsp;<code>tx_mtvc2_sweep_stats<\/code>, has been added for telemetry on the ADR PVS multi-threaded version cleaner.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p>In this blog post, we covered all the exciting ADR improvements that we are including with SQL Server 2022 that further improve the overall availability and scalability of your databases.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.webp\" alt=\"Side by side comparison graphs of recovery times after SQL restart with ADR\" class=\"wp-image-49343 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.webp\"><figcaption class=\"wp-element-caption\">Figure 1: 5M rows bulk insert and recovery times after SQL restart with ADR on and off (side by side comparison)<\/figcaption><\/figure>\n\n\n\n<p>Stay tuned as we are currently working on further improvements of the multi-threaded version cleaner that will enable parallelizing version cleanup within databases.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more\">Learn more<\/h2>\n\n\n\n<p>For more information, and to get started with <a href=\"https:\/\/www.microsoft.com\/sql-server\/sql-server-2022\">SQL Server 2022<\/a>, check out the following references:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/accelerated-database-recovery-management?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Manage accelerated database recovery<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/accelerated-database-recovery-troubleshoot?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Troubleshoot accelerated database recovery<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/accelerated-database-recovery-management?source=recommendations&amp;view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Accelerated Database Recovery<\/a><\/li>\n<\/ul>\n\n\n\n<p>Read <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-2022?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">What\u2019s new in SQL Server 2022<\/a> for all the new features on security, platform, management, and more.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.<\/p>\n","protected":false},"author":6194,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[5278],"product":[5227,3645],"content-type":[2448],"topic":[],"coauthors":[5146],"class_list":["post-49323","post","type-post","status-publish","format-standard","hentry","tag-sql-server-2022-blogging-series","product-sql","product-sql-server-2022","content-type-updates","review-flag-1-1593580431-15","review-flag-4-1593580446-456","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Accelerated Database Recovery enhancements in SQL Server 2022\u00a0 - Microsoft SQL Server Blog<\/title>\n<meta name=\"description\" content=\"We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.\" \/>\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.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-28T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-31T21:37:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.png\" \/>\n<meta name=\"author\" content=\"Perry Skountrianos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Perry Skountrianos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/perry-skountrianos\/\",\"@type\":\"Person\",\"@name\":\"Perry Skountrianos\"}],\"headline\":\"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0\",\"datePublished\":\"2023-03-28T15:00:00+00:00\",\"dateModified\":\"2024-01-31T21:37:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/\"},\"wordCount\":906,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.png\",\"keywords\":[\"SQL Server 2022 Blogging Series\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/\",\"name\":\"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.png\",\"datePublished\":\"2023-03-28T15:00:00+00:00\",\"dateModified\":\"2024-01-31T21:37:09+00:00\",\"description\":\"We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.webp\",\"width\":624,\"height\":359,\"caption\":\"chart\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0 - Microsoft SQL Server Blog","description":"We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.","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.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/","og_locale":"en_US","og_type":"article","og_title":"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0 - Microsoft SQL Server Blog","og_description":"We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2023-03-28T15:00:00+00:00","article_modified_time":"2024-01-31T21:37:09+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.png","type":"","width":"","height":""}],"author":"Perry Skountrianos","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Perry Skountrianos","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/perry-skountrianos\/","@type":"Person","@name":"Perry Skountrianos"}],"headline":"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0","datePublished":"2023-03-28T15:00:00+00:00","dateModified":"2024-01-31T21:37:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/"},"wordCount":906,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.png","keywords":["SQL Server 2022 Blogging Series"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/","name":"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.png","datePublished":"2023-03-28T15:00:00+00:00","dateModified":"2024-01-31T21:37:09+00:00","description":"We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2023\/03\/ADR-Blog-Image-1.webp","width":624,"height":359,"caption":"chart"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/03\/28\/accelerated-database-recovery-enhancements-in-sql-server-2022\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Accelerated Database Recovery enhancements in SQL Server 2022\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/49323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/6194"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=49323"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/49323\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=49323"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=49323"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=49323"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=49323"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=49323"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=49323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}