{"id":5827,"date":"2014-10-01T00:00:00","date_gmt":"2014-10-01T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-sql-database-point-in-time-restore"},"modified":"2025-09-15T10:24:55","modified_gmt":"2025-09-15T17:24:55","slug":"azure-sql-database-point-in-time-restore","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/","title":{"rendered":"Azure SQL Database Point in Time Restore"},"content":{"rendered":"\n<h5 class=\"wp-block-heading\" id=\"updated-on-3-3-2017-for-updated-content-on-this-topic-visit-this-article-learn-about-sql-database-backups-on-our-docs-site\"><strong>[Updated on 3\/3\/2017] <\/strong>For updated content on this topic visit this article: <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-automated-backups\">Learn about SQL Database backups<\/a> on our docs site.<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>[Updated on 01\/22\/2016]<\/strong> Improvement&nbsp;to the Estimated Recovery Time (ERT) and Recovery Point Objective (RPO) for Basic, Standard and Premium database tiers. &nbsp; In this final post in our series on Business Continuity I\u2019m going to look at <i>point-in-time restore<\/i>, a self-service feature available for Basic, Standard, and Premium databases. In previous posts I described the Azure SQL Database business continuity model which includes point-in-time restore. This model is summarized in the table below. Within this model point-in-time restore is designed for recovering a database from a recent backup after accidental data corruption or deletion.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>\n<p align=\"center\"><b>BCDR option<\/b><\/p>\n<\/td><td>\n<p align=\"center\"><b>Basic tier<\/b><\/p>\n<\/td><td>\n<p align=\"center\"><b>Standard tier<\/b><\/p>\n<\/td><td>\n<p align=\"center\"><b>Premium tier<\/b><\/p>\n<\/td><\/tr><tr><td>Point In Time Restore<\/td><td>Any restore point within 7 days<\/td><td>Any restore point within 35 days<\/td><td>Any restore point within 35 days<\/td><\/tr><tr><td>Geo-Restore<\/td><td>ERT* &lt; 12h RPO\u2020 &lt; 1h<\/td><td>ERT*&nbsp;&lt; 12h RPO\u2020 &lt; 1h<\/td><td>ERT*&nbsp;&lt; 12h RPO\u2020 &lt; 1h<\/td><\/tr><tr><td>Standard Geo-Replication<\/td><td>Not included<\/td><td>ERT*&nbsp;&lt; 30s RPO\u2020 &lt; 5s<\/td><td>ERT*&nbsp;&lt; 30s RPO\u2020 &lt; 5s<\/td><\/tr><tr><td>Active Geo-Replication<\/td><td>Not included<\/td><td>Not included<\/td><td>ERT*&nbsp;&lt; 30s RPO\u2020 &lt; 5s<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">* Estimated Recovery Time (ERT) &#8211; The estimated duration for the database to be fully functional after a restore\/failover request. \u2020 Recovery Point Objective (RPO) &#8211; The amount of most recent data changes (time interval) the application could lose after recovery.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-point-in-time-restore\">What is Point in Time Restore?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Azure SQL Database service protects all databases with an automated backup system. These backups are retained for 7 days for Basic, 35 days for Standard and 35 days for Premium. Point-in-time restore is a self-service capability, allowing customers to restore a Basic, Standard or Premium database from these backups to any point within the retention period. Point-in-time restore always creates a new database. The database backups are taken automatically with no need to opt-in and no additional charges. You only incur additional cost if you use the restore capability. The new database created by restore is charged at normal database rates. Together, the automated backup system and point-in-time restore provide a zero-cost, zero-admin way to protect databases from accidental corruption or deletion, whatever the cause. &nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"understanding-automatic-backups\">Understanding Automatic Backups<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">All Basic, Standard, and Premium databases are protected by automatic backups. Full backups are taken every week, differential backups every day, and log backups every 5 minutes. The first full backup is scheduled immediately after a database is created. Normally this completes within 30 minutes but it can take longer. If a database is \u201cborn big\u201d, for example if it is created as the result of database copy or restore from a large database, then the first full backup may take longer to complete. After the first full backup all further backups are scheduled automatically and managed silently in the background. Exact timing of full and differential backups is determined by the system to balance overall load. Backup files are stored in geo-redundant storage account with read access (RA-GRS) to ensure backups\u2019 availability for disaster recovery purposes. When you restore a database, the required backup files are retrieved in the same data center and applied. When <a href=\"https:\/\/azure.microsoft.com\/blog\/2014\/09\/13\/azure-sql-database-geo-restore\/\">geo-restore<\/a> is invoked the geo-redundant copy of the backups are retrieved and applied as described in my last post. &nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"restoring-a-live-database-to-a-point-in-time\">Restoring a Live Database to a Point in Time<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Using the Azure Management Portal it\u2019s a simple operation to restore a live Basic, Standard, or Premium database to any point in time within its retention period. Either select the database in the list of databases, or open it in the database dashboard, and choose the restore option.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.webp\" alt=\"graphical user interface\" class=\"wp-image-8920 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You will be prompted for a new database name and offered a slider control to pick the restore point within the retention period. Alternatively, you can manually enter the date and time to the nearest minute. Once you confirm the action, the database will be restored.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreSettings_thumb.webp\" alt=\"Specify restore settings window\" class=\"wp-image-8922 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreSettings_thumb.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The time taken to restore the database depends on many factors, including the size of the database, the time point selected, and the amount of activity that needs to be replayed to reconstruct the state at the selected point. For a very large and\/or active database restore may take several hours. Restoring a database always creates a new database on the same server as the original database, so the restored database must be given a new name. The database is restored using the service tier that was applicable at the restore point with its default performance level. You need to ensure you have sufficient <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/ee336245.aspx#DTUs\">DTU quota<\/a> on the server bearing in mind that the restore creates a new database and that the service tier and performance level of the restored database may be different to the current state of the live database. Once complete, the restored database is a normal fully accessible online database charged at normal rates based on its service tier and performance level. If you are restoring the database for recovery purposes you can treat the restored database as a replacement for the original database, or use it to retrieve data from and then update the original database. If the restored database is intended as a replacement for the original database you should verify the performance level and\/or service tier are appropriate and scale the database if necessary. You can rename the original database and then give the restored database the original name using the ALTER DATABASE command in T-SQL. If you plan to retrieve data from the restored database you will separately need to write and execute whatever data recovery scripts you need. Although the restore operation may take a long time to complete the database will be visible in the database list throughout. If you delete the database during the restore it will cancel the operation and you will not be charged. <\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreMonitoring_thumb.webp\" alt=\"graphical user interface, application\" class=\"wp-image-8924 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreMonitoring_thumb.webp\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"restoring-a-recently-deleted-database\">Restoring a Recently Deleted Database<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you delete a Basic, Standard, or Premium database the final backup is retained for the normal retention period allowing you to restore the database to the point at which it was deleted. To restore a deleted database in the Azure Management Portal you need to open the Deleted Databases tab and locate the appropriate database entry.  &nbsp; <\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreDroppedDB1_thumb.webp\" alt=\"graphical user interface, text, application\" class=\"wp-image-8926 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreDroppedDB1_thumb.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Note that if you have reused the same database name multiple times you will need to pay careful attention to the deletion time on each database to ensure you restore the correct one. <\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreDroppedDB2_thumb.webp\" alt=\"graphical user interface, text, application\" class=\"wp-image-8928 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreDroppedDB2_thumb.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As before you need to provide a name for the new database, but in this case the restore point is fixed to the deletion time of the database. And as before, when restoring a deleted database, it can only be restored to the server that contained the original database. Be mindful of this when deleting a server as you will not be able to restore databases previously located on that server once it is deleted. &nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"backup-restore-vs-copy-export-import\">Backup\/Restore vs. Copy\/Export\/Import<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Point-in-time restore is the recommended approach for recovering Basic, Standard, and Premium databases from accidental data loss or corruption. Point-in-time restore removes the need to use the costly workaround based on copy and export\/automated export to create backups that is required with Web and Business databases. This improvement alone may justify upgrading to one of the new service tiers. Backup and restore is lower cost (there are no charges for backups unless they are <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/jj650016.aspx#\">excessive<\/a>, whereas you are charged for the database copy needed to ensure a transactional consistent export and for storing the BACPAC file), zero admin (backups are automatic, whereas you must manage or schedule exports yourself) and has a better RPO (you can restore to a specific point in time with much finer (one minute) granularity than is practical with copy\/export\/import) and a better recovery time&nbsp;(restore from backups is typically much faster than import, which involves steps to create the schema, disable indexes, load data, and then enable indexes for each table individually). Note that copy and export continues to be the recommended solution for long term archival beyond the retention period. &nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"using-apis-to-restore-databases\">Using APIs to Restore Databases<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In addition to using the Azure Management Portal you can also restore databases using PowerShell using the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn720218.aspx\">Start-AzureSqlDatabaseRestore<\/a> cmdlet, and the SQL Database management API <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/dn509571.aspx\">Create Database Restore Request<\/a>. &nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Automatic backups and self-service point-in-time restore protect your databases from accidental data corruption or deletion. This zero-cost zero-admin solution is available with all Basic, Standard, and Premium databases. Backup and restore provides a significant improvement over the alternative copy\/export\/import solution for short term recovery needs. We encourage you to use point-in-time restore as part of your business continuity strategy, and only to use export as needed for longer term archival or data migration purposes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this final post in our series on Business Continuity I\u2019m going to look at point-in-time restore, a self-service feature available for Basic, Standard, and Premium databases.<\/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-5827","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-3-1680286581-173","review-flag-5-1680286581-950","review-flag-7-1680286581-146","review-flag-alway-1680286580-106","review-flag-and-o-1680286581-349","review-flag-disable","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 Point in Time Restore | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"In this final post in our series on Business Continuity I\u2019m going to look at point-in-time restore, a self-service feature available for Basic, Standard, and Premium databases.\" \/>\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-point-in-time-restore\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure SQL Database Point in Time Restore | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"In this final post in our series on Business Continuity I\u2019m going to look at point-in-time restore, a self-service feature available for Basic, Standard, and Premium databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/\" \/>\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=\"2014-10-01T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-15T17:24:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_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=\"8 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-point-in-time-restore\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Azure SQL Database Point in Time Restore\",\"datePublished\":\"2014-10-01T00:00:00+00:00\",\"dateModified\":\"2025-09-15T17:24:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/\"},\"wordCount\":1453,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_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-point-in-time-restore\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/\",\"name\":\"Azure SQL Database Point in Time Restore | 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-point-in-time-restore\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.png\",\"datePublished\":\"2014-10-01T00:00:00+00:00\",\"dateModified\":\"2025-09-15T17:24:55+00:00\",\"description\":\"In this final post in our series on Business Continuity I\u2019m going to look at point-in-time restore, a self-service feature available for Basic, Standard, and Premium databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.webp\",\"width\":604,\"height\":509,\"caption\":\"graphical user interface\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#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 Point in Time Restore\"}]},{\"@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 Point in Time Restore | Microsoft Azure Blog","description":"In this final post in our series on Business Continuity I\u2019m going to look at point-in-time restore, a self-service feature available for Basic, Standard, and Premium databases.","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-point-in-time-restore\/","og_locale":"en_US","og_type":"article","og_title":"Azure SQL Database Point in Time Restore | Microsoft Azure Blog","og_description":"In this final post in our series on Business Continuity I\u2019m going to look at point-in-time restore, a self-service feature available for Basic, Standard, and Premium databases.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2014-10-01T00:00:00+00:00","article_modified_time":"2025-09-15T17:24:55+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_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":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Azure SQL Database Point in Time Restore","datePublished":"2014-10-01T00:00:00+00:00","dateModified":"2025-09-15T17:24:55+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/"},"wordCount":1453,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_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-point-in-time-restore\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/","name":"Azure SQL Database Point in Time Restore | 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-point-in-time-restore\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.png","datePublished":"2014-10-01T00:00:00+00:00","dateModified":"2025-09-15T17:24:55+00:00","description":"In this final post in our series on Business Continuity I\u2019m going to look at point-in-time restore, a self-service feature available for Basic, Standard, and Premium databases.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2014\/10\/RestoreLiveDB1_thumb.webp","width":604,"height":509,"caption":"graphical user interface"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-database-point-in-time-restore\/#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 Point in Time Restore"}]},{"@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\/5827","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=5827"}],"version-history":[{"count":2,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5827\/revisions"}],"predecessor-version":[{"id":46232,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/5827\/revisions\/46232"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=5827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=5827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=5827"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=5827"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=5827"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=5827"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=5827"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=5827"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=5827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}