Azure SQL Data

After a backup policy successfully creates a restore point of an Azure SQL database according to the specified schedule, or after you create a backup of a database manually, Veeam Backup for Microsoft Azure adds the database to the resource list on the Protected Data tab.

The Protected Data tab displays Azure resources that are already protected by Veeam Backup for Microsoft Azure. Each resource is represented with a set of properties, such as:

  • Database — the name of the Azure SQL database.
  • Server Name — the name of the SQL Server where the protected Azure SQL database is located.
  • Policy — the name of the backup policy that protects the Azure SQL database.
  • Restore Points — the number of restore points created for the Azure SQL database.

To view the list of restore points, click the link in the Restore Points column. The Available Restore Points window displays information on each restore point of an Azure SQL database, including the date when the restore point was created, access tier of the backup repository where the restore point is stored and so on. The letter displayed in the Retention column defines whether the restore point has daily (D), weekly (W), monthly (M) or yearly (Y) retention configured in the backup policy settings.

  • Latest Backup — the date and time of the most recent restore point created for the Azure SQL database.
  • Backup Size — the total size of the standard Azure SQL database backups.
  • Archive Size — the total size of the Azure SQL database backups stored in archive repositories.
  • Region — the region in which the Azure SQL database resides.
  • Resource Group — the resource group that stores resources related to the Azure SQL database.
  • SQL Elastic Pool — the name of the elastic pool to which the Azure SQL database is added.
  • Data Retrieval — the status of the backups retrieval from the archive repository.
  • Tenant ID — the unique identification number of the Azure AD tenant that contains the Azure SQL database.
  • Subscription ID — the unique identification number of the Azure subscription that is used to manage costs of the Azure SQL database.

On the Protected Data tab, you can also perform the following actions:

Managing SQL Data