-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Professional Azure SQL Managed Database Administration
By :

This section discusses the different types of restore available in Azure SQL Database and SQL Managed Instance.
Point-in-time restore (PITR) isn't new in the world of SQL Server. On-premises SQL servers allow you to restore a database to a particular point in time by specifying the point-in-time option when restoring the database using the restore
command.
Azure SQL Database and SQL Managed Instance backups are managed by the automatic backups feature of the PaaS offering. Point-in-time restores can only be performed using the Azure portal, PowerShell, the Azure CLI, or the Azure SDK. PITR uses the automatic Full, Differential, and Log backups.
For all new, restored, and copied databases on Azure SQL Database and SQL Managed Instance, the default retention period is 7 days. The retention period can be adjusted for existing or deleted databases (the latter is only available on SQL Managed Instance):