Perform Database Backups for Long-Term Retention

By default, a Privilege Management implementation in Azure has Point In Time Recovery (PITR) enabled for seven days. However, if you wish to enable a long-term backup retention policy (LTR) for any of your Management, Blob, or Reporting databases, you may configure the policy to retain backups in separate Blob storage containers for up to ten years.

Microsoft provides LTR backup services at an additional cost. You can use the Azure pricing calculator to learn more.

  1. In the Azure portal, navigate to Azure Services > SQL servers.
  2. Select the SQL server that contains the database you wish to back up.
  3. Click Manage Backups.
  4. Ensure you are on the Configure policies tab.
  5. Check the box to select the desired database.
  6. Click Configure Retention.

On the Configure policies tab, select the database you wish to back up and click Configure Retention.

An example of long range retention policy settings

  1. In the Configure policies pane, check any of the Weekly, Monthly, or Yearly LTR Backups boxes, and choose the retention period for each.
  2. Click Apply.


Once you have made a backup, you can restore it from the Manage Backups pane, on the Available backups tab.

For more information, please see Manage Azure SQL Database long-term backup retention.