Protecting Azure SQL Databases

To produce backups of Azure SQL databases, Veeam Backup for Microsoft Azure runs backup policies. A backup policy is a collection of settings that define the way backup operations are performed: what data to back up, where to store backups, when to start the backup process, and so on.

Veeam Backup for Microsoft Azure does not install agent software to back up Azure SQL data — it uses native Microsoft Azure capabilities instead. During every backup session, Veeam Backup for Microsoft Azure creates a BACPAC file for each Azure SQL database added to a backup policy. The BACPAC file is further used to create a backup of the Azure SQL database. For more information on how SQL backup works, see SQL Backup.

How To Protect Azure SQL databases

To create an Azure SQL backup policy, perform the following steps:

  1. Check limitations and prerequisites.
  2. Specify service accounts to access Azure services and resources.
  3. [Optional] Add backup repositories to store backed-up data.
  4. [Optional] Configure worker instance settings to launch workers while processing Azure SQL data.
  5. [Optional] Configure global retention settings for obsolete session records.
  6. [Optional] Configure email notification settings for automated delivery of backup policy results and daily reports.
  7. Complete the Add Azure SQL Policy wizard.

Related Topics

SQL Restore