{"id":38908,"date":"2025-05-23T16:28:10","date_gmt":"2025-05-23T14:28:10","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=38908"},"modified":"2025-05-23T16:28:10","modified_gmt":"2025-05-23T14:28:10","slug":"sql-server-2025-backups-to-secondary-replicas-of-an-availability-group","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/","title":{"rendered":"SQL Server 2025 &#8211; Backups to secondary replicas of an availability group"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Backup operations can increase significantly I\/O and even CPU utilization when we use backup compression. To avoid using resources on primary replica, offloading backups to a synchronized or synchronizing replicas seems to be the good solution even if we have some limitations.<br>For the time being, supported backups on a secondary replicas are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Full backup with copy_only<\/li>\n\n\n\n<li>Transaction log backup<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">So we cannot perform:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Normal Full backup<\/li>\n\n\n\n<li>Differential backup<\/li>\n\n\n\n<li>Transaction Log backup with copy_only<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Those limitations may cause some problems during point-in-time restore as with copy_only backup point-in-time restore is not possible. This can lead to point-in-time restore taking lots of time because the last Full backup without copy-only is far away on time and we need to apply thousands of transaction log backups or in worst inability to execute point-in-time restore&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With <a href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-public-preview-and-ssms-21-now-available\/\">SQL Server 2025<\/a>, not just Full backups with copy_only are available on secondary replicas, it introduces normal Full backups as well as Differential backups.<br>To perform those new backups on secondary replicas we need to enable specific trace flags:<\/p>\n\n\n\n<ul class=\"nv-cv-m wp-block-list\">\n<li>Trace flag 3261 will enable differential backups on secondary replicas<\/li>\n\n\n\n<li>Trace flag 3262 will enable full backups on secondary replicas<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">First of all we need to install the new <a href=\"https:\/\/learn.microsoft.com\/en-us\/ssms\/release-notes-21\">SQL Server Management Studio 21<\/a>, two SQL Server 2025 CTP2 instances and configure an Always On Availability Group with backup Preferences set to Prefer Secondary.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before to try the new Full and Differential backups on a secondary replica with the trace flags, lets try to run a Full backup without copy_only on a secondary:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1486\" height=\"518\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg\" alt=\"\" class=\"wp-image-38920\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg 1486w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1-300x105.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1-1024x357.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1-768x268.jpg 768w\" sizes=\"auto, (max-width: 1486px) 100vw, 1486px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As expected it fails.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lets try to configure those new backups and enable the new trace flags, here globally, but we will do it with -T in the startup parameters of the SQL Service to persist them later on:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"813\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_2.jpg\" alt=\"\" class=\"wp-image-38921\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_2.jpg 972w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_2-300x251.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_2-768x642.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Once done on my two cluster nodes, I will try to execute a Full backup of the AdventureWorks database on a secondary replica:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"482\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_3-1024x482.jpg\" alt=\"\" class=\"wp-image-38922\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_3-1024x482.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_3-300x141.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_3-768x362.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_3.jpg 1423w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">My Full backup succeeds and it&#8217;s not a Full backup with copy_only but a normal one:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"997\" height=\"371\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_4.jpg\" alt=\"\" class=\"wp-image-38923\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_4.jpg 997w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_4-300x112.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_4-768x286.jpg 768w\" sizes=\"auto, (max-width: 997px) 100vw, 997px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We can also execute a Differential backup and as we can see my Incremental backup has been executed successfully:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_5-1024x380.jpg\" alt=\"\" class=\"wp-image-38924\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_5-1024x380.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_5-300x111.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_5-768x285.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_5.jpg 1417w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"362\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_6-1024x362.jpg\" alt=\"\" class=\"wp-image-38925\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_6-1024x362.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_6-300x106.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_6-768x271.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_6.jpg 1116w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Removing the backup workload from the primary replica and relocate it on the secondary is a great benefit. Before SQL Server 2025, this configuration was not robust as it should be due to the copy_only restriction and the inability to execute Differential backup.<br>With this new version no doubt that more and more customers will move to this configuration. Of course backup jobs need to be tuned to just execute the backup when the database is on its preferred backup replica but most of the backup jobs already check that \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Backup operations can increase significantly I\/O and even CPU utilization when we use backup compression. To avoid using resources on primary replica, offloading backups to a synchronized or synchronizing replicas seems to be the good solution even if we have some limitations.For the time being, supported backups on a secondary replicas are: So we cannot&hellip;&nbsp;<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"closed","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":[4133,99],"tags":[202,3618],"class_list":["post-38908","post","type-post","status-publish","format-standard","category-database","category-sql-server","tag-backup","tag-sql-server-2025"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2025 - Backups to secondary replicas of an availability group - dbi services Blog<\/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:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2025 - Backups to secondary replicas of an availability group\" \/>\n<meta property=\"og:description\" content=\"Backup operations can increase significantly I\/O and even CPU utilization when we use backup compression. To avoid using resources on primary replica, offloading backups to a synchronized or synchronizing replicas seems to be the good solution even if we have some limitations.For the time being, supported backups on a secondary replicas are: So we cannot&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/\" \/>\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=\"2025-05-23T14:28:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1486\" \/>\n\t<meta property=\"og:image:height\" content=\"518\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\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 Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/adf6293d8bc8a7a26490acfe2918b6d7\"},\"headline\":\"SQL Server 2025 &#8211; Backups to secondary replicas of an availability group\",\"datePublished\":\"2025-05-23T14:28:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/\"},\"wordCount\":457,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/SQL_Server_2025_Backup_1.jpg\",\"keywords\":[\"Backup\",\"SQL Server 2025\"],\"articleSection\":[\"Database\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/\",\"name\":\"SQL Server 2025 - Backups to secondary replicas of an availability group - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/SQL_Server_2025_Backup_1.jpg\",\"datePublished\":\"2025-05-23T14:28:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/SQL_Server_2025_Backup_1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/SQL_Server_2025_Backup_1.jpg\",\"width\":1486,\"height\":518},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2025 &#8211; Backups to secondary replicas of an availability group\"}]},{\"@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\\\/#organization\"},\"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\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"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 specialized 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\\\/adf6293d8bc8a7a26490acfe2918b6d7\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-savorgnano\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2025 - Backups to secondary replicas of an availability group - dbi services Blog","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-2025-backups-to-secondary-replicas-of-an-availability-group\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2025 - Backups to secondary replicas of an availability group","og_description":"Backup operations can increase significantly I\/O and even CPU utilization when we use backup compression. To avoid using resources on primary replica, offloading backups to a synchronized or synchronizing replicas seems to be the good solution even if we have some limitations.For the time being, supported backups on a secondary replicas are: So we cannot&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2025-05-23T14:28:10+00:00","og_image":[{"width":1486,"height":518,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/adf6293d8bc8a7a26490acfe2918b6d7"},"headline":"SQL Server 2025 &#8211; Backups to secondary replicas of an availability group","datePublished":"2025-05-23T14:28:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/"},"wordCount":457,"commentCount":2,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg","keywords":["Backup","SQL Server 2025"],"articleSection":["Database","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/","name":"SQL Server 2025 - Backups to secondary replicas of an availability group - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg","datePublished":"2025-05-23T14:28:10+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/SQL_Server_2025_Backup_1.jpg","width":1486,"height":518},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-backups-to-secondary-replicas-of-an-availability-group\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2025 &#8211; Backups to secondary replicas of an availability group"}]},{"@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\/#organization"},"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\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","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 specialized 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\/adf6293d8bc8a7a26490acfe2918b6d7","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38908","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\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=38908"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38908\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=38908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=38908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=38908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}