Restore to a point-in-time
Applies to: SQL Server
This task creates a new database as a copy of another database. The new database is restored from backup to a point-in-time in the past that is within the retention period.
You can restore a database to a point-in-time:
- From an existing database
- To a new database on the same Arc-enabled SQL Server instance
The latest updates are available in the Release notes - SQL Server enabled by Azure Arc.
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.
To restore to a point-in-time from Azure portal:
Browse to the Arc-enabled SQL Server
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
- 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.