Restore to a point-in-time
Applies to:
SQL Server
This article demonstrates how to restore a database to a point-in-time as a new database on the same instance of SQL Server enabled by Azure Arc.
The new database is restored from backup to a point-in-time in the past that is within the retention period.
Note
As a preview feature, the technology presented in this article is subject to Supplemental Terms of Use for Microsoft Azure Previews.
The latest updates are available in the Release notes - SQL Server enabled by Azure Arc.
Prerequisite
Before you can restore a database to a point-in-time with the instructions in this article, you have to enable automatic backups. For instructions, see Manage automated backups - SQL Server enabled by Azure Arc.
Automated backups are disabled by default.
Steps
To restore to a point-in-time from Azure portal:
Browse to the Arc-enabled SQL Server
Select Backups
Among the list of databases on the right pane, select Restore for the database you want to restore.
Azure portal guides you through the instructions to create a database with the selected database as the source database.
Provide details such as the point-in-time to restore to, and the name for the new database.
Proceed through the wizard to submit the restore deployment
Limitations
- The process described in this article requires the backup be taken by an automated backup from an instance of SQL Server enabled by Azure Arc. For instructions, see Manage automated backups - SQL Server enabled by Azure Arc.