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.
Related tasks
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho