{"id":5510,"date":"2015-04-15T00:00:00","date_gmt":"2015-04-15T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-sql-database-built-in-backups-vs-importexport-2"},"modified":"2025-09-17T08:09:11","modified_gmt":"2025-09-17T15:09:11","slug":"azure-sql-database-built-in-backups-vs-importexport-2","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/","title":{"rendered":"Azure SQL Database: Built-in Backups vs Import\/Export"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">With the release of the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/dn741336.aspx\">Basic, Standard, and Premium<\/a> Azure SQL Database service tiers, we provide <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/jj650016.aspx\">built-in backup and restore capabilities<\/a>. These new capabilities help reduce the need to perform manual backups for disaster recovery, recovery of accidental data corruption, and recovery of deleted data, using the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/hh335292.aspx\">Import\/Export service<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The table below is a quick comparison of the Import\/Export and the built-in backup restore capabilities.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>&nbsp;<\/td><td>\n<p align=\"center\">Designed for Disaster Recovery<\/p>\n<\/td><td>\n<p align=\"center\">Support <a title=\"Point in Time Restore\" href=\"https:\/\/azure.microsoft.com\/blog\/2014\/10\/01\/azure-sql-database-point-in-time-restore\/\">PITR<\/a><\/p>\n<\/td><td>\n<p align=\"center\">No operational overhead<\/p>\n<\/td><td>\n<p align=\"center\">Transactional consistent backups<\/p>\n<\/td><td>\n<p align=\"center\">No additional cost<\/p>\n<\/td><td>\n<p align=\"center\">Restore to On-Premises<\/p>\n<\/td><\/tr><tr><td>\n<p align=\"center\">DB Export<\/p>\n<\/td><td>\n<p align=\"center\">No<\/p>\n<\/td><td>\n<p align=\"center\">No<\/p>\n<\/td><td>\n<p align=\"center\">Export needs to be externally triggered<\/p>\n<\/td><td>\n<p align=\"center\">Required DB copy before backup.<\/p>\n<\/td><td>\n<p align=\"center\">Storage and extra DB cost.<\/p>\n<\/td><td>\n<p align=\"center\">Yes<\/p>\n<\/td><\/tr><tr><td>\n<p align=\"center\">Built-in Backup<\/p>\n<\/td><td>\n<p align=\"center\">Yes<\/p>\n<\/td><td>\n<p align=\"center\">Yes<\/p>\n<\/td><td>\n<p align=\"center\">Yes<\/p>\n<\/td><td>\n<p align=\"center\">Yes<\/p>\n<\/td><td>\n<p align=\"center\">Yes<\/p>\n<\/td><td>\n<p align=\"center\">No<\/p>\n<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-are-azure-sql-database-built-in-backups\">What are Azure SQL Database Built-in Backups?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Basic, standard, and premium databases are backed up automatically in Azure SQL Database. These backups are retained for 7 days, 14 days, and 35 days respectively. With these backups Azure SQL Database supports two restore capabilities.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/azure.microsoft.com\/blog\/2014\/10\/01\/azure-sql-database-point-in-time-restore\/\">Point in Time Restore<\/a> allows a database to be restored to any point in time, up to the millisecond, within a database\u2019s retention period.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/azure.microsoft.com\/blog\/2014\/09\/13\/azure-sql-database-geo-restore\/\">Geo-Restore<\/a> utilizes a database\u2019s latest geo-redundant backup to recover a database. This means a database can be recovered in the event of a regional outage with the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/hh852669.aspx\">1 hour old geo-redundant backup<\/a>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-was-export-used-for-backup\">How was Export used for Backup?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before the built-in backup capabilities were available, Export was used as a mechanism for backing up a database.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.webp\" alt=\"diagram\" class=\"wp-image-9224 webp-format\" title=\"clip_image001[8]\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The process for creating a BACPAC file using export is the following: <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The copy of the database is used to guarantee transaction consistency of the BACPAC file. This copy is treated as a second database and is billed as such.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"geo-restore-vs-hourly-export\">Geo-Restore vs Hourly Export<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Matching the functionality of Geo-Restore would require an export to be taken every hour. Every hour a database copy would need to be made then exported into geo-redundant storage. Depending on the size of the database and its schema, it may take longer than 1 hour to complete the export.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Over the course of a month, the costs end up being roughly the same as running an entire second database just for backup, and even with all the extra management work, you still may not even be able to meet the same recovery point objective (RPO) that Geo-Restore offers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"point-in-time-restore-vs-export\">Point in Time Restore vs Export<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Point in Time Restore allows you to restore a database to any point in time, up to the millisecond, within the database\u2019s retention period. The Export technology cannot provide the same fine restore granularity.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusions\">Conclusions<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The built-in backup and restore capabilities offered by Azure SQL Database provide great functionality for recovering from disaster and human error (oops mistakes). Accomplishing these same functionalities with Import\/Export could be costly and incur a lot of operational overhead.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Import\/Export cannot entirely be replaced by the built-in backups. Import\/Export, along with <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/ee730904.aspx\">client tools like SSDT and SSMS<\/a>, is still recommended for migrating data in and out of Azure SQL Database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It\u2019s time to reduce your operational overhead by moving to Basic, Standard, or Premium databases and stopping manual backup with Export!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-s-next\">What\u2019s next?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Learn how to use Azure SQL Database built-in restore capabilities.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-geo-restore-tutorial-management-portal\/\">How To Geo-Restore<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-point-in-time-restore-tutorial-management-portal\/\">How To Point in Time Restore<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-restore-deleted-database-tutorial-management-portal\/\">How To Restore a Deleted Database<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Learn more about the built-in restore capabilities.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/jj650016.aspx\">SQL Database Backup and Restore<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/hh852669.aspx\">SQL Database Business Continuity<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>With the release of the Basic, Standard, and Premium Azure SQL Database service tiers, we provide built-in backup and restore capabilities.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1466],"tags":[],"audience":[3057,3055,3056],"content-type":[1511],"product":[1539],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-5510","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","audience-data-professionals","audience-developers","audience-it-implementors","content-type-best-practices","product-azure-sql-database","review-flag-1680286581-295","review-flag-1-1680286581-825","review-flag-7-1680286581-146","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure SQL Database: Built-in Backups vs Import\/Export | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"With the release of the Basic, Standard, and Premium Azure SQL Database service tiers, we provide built-in backup and restore capabilities.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure SQL Database: Built-in Backups vs Import\/Export | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"With the release of the Basic, Standard, and Premium Azure SQL Database service tiers, we provide built-in backup and restore capabilities.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-15T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-17T15:09:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.png\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\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:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Azure SQL Database: Built-in Backups vs Import\/Export\",\"datePublished\":\"2015-04-15T00:00:00+00:00\",\"dateModified\":\"2025-09-17T15:09:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/\"},\"wordCount\":567,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.png\",\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/\",\"name\":\"Azure SQL Database: Built-in Backups vs Import\/Export | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.png\",\"datePublished\":\"2015-04-15T00:00:00+00:00\",\"dateModified\":\"2025-09-17T15:09:11+00:00\",\"description\":\"With the release of the Basic, Standard, and Premium Azure SQL Database service tiers, we provide built-in backup and restore capabilities.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.webp\",\"width\":623,\"height\":190,\"caption\":\"diagram\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Azure SQL Database: Built-in Backups vs Import\/Export\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure SQL Database: Built-in Backups vs Import\/Export | Microsoft Azure Blog","description":"With the release of the Basic, Standard, and Premium Azure SQL Database service tiers, we provide built-in backup and restore capabilities.","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:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/","og_locale":"en_US","og_type":"article","og_title":"Azure SQL Database: Built-in Backups vs Import\/Export | Microsoft Azure Blog","og_description":"With the release of the Basic, Standard, and Premium Azure SQL Database service tiers, we provide built-in backup and restore capabilities.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2015-04-15T00:00:00+00:00","article_modified_time":"2025-09-17T15:09:11+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.png","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Azure SQL Database: Built-in Backups vs Import\/Export","datePublished":"2015-04-15T00:00:00+00:00","dateModified":"2025-09-17T15:09:11+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/"},"wordCount":567,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.png","articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/","name":"Azure SQL Database: Built-in Backups vs Import\/Export | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.png","datePublished":"2015-04-15T00:00:00+00:00","dateModified":"2025-09-17T15:09:11+00:00","description":"With the release of the Basic, Standard, and Premium Azure SQL Database service tiers, we provide built-in backup and restore capabilities.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2015\/04\/clip_image0018_thumb.webp","width":623,"height":190,"caption":"diagram"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-built-in-backups-vs-importexport-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Azure SQL Database: Built-in Backups vs Import\/Export"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=5510"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5510\/revisions"}],"predecessor-version":[{"id":46411,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5510\/revisions\/46411"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=5510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=5510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=5510"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=5510"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=5510"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=5510"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=5510"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=5510"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=5510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}