Azure SQL database point in time restore.

Question

I have a Basic Pay-as-you-go plan with Azure and one SQL database. I need to restore the data for just one of the tables. I only see an option to restore the whole database as a brand-new database with a monthly fee. Is there a way to get a backup from a certain day as a file and restore it locally on a SQL Server without paying any fees?

Answer 1

Hi Alina,

What you can do is restore certain day to a brand-new database, export that database to BACPAC file, delete the brand-new database, download BACPAC file to local machine, import BACPAC to local SQL Server. In this way the new database will not exist for very long (minutes), so you will only be charged a small amount, especially for Basic.

Please see articles below for how to export to BACPAC and import the BACPAC file.

Export to a BACPAC file - Azure SQL Database and Azure SQL Managed Instance

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql

Import a BACPAC File to Create a New User Database

https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/import-a-bacpac-file-to-create-a-new-user-database?view=sql-server-ver16

After you are done downloading the BACPAC file you should delete it from the storage account so that charges don't continue to accrue.

Please click Accept Answer and upvote if the above was helpful. Add a comment below if something is unclear.

Thanks.

-TP