Azure SQL Database and Long-Term Backups

There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server.

As you can see, by default we have 7 days retention to allow for PITR – Point In Time Recovery, anything longer you will need to setup long term retention.

Long term is based on 4 parameters and your requirements will dictate how you want to set this up. For example, the parameters are:

  • weekly backup retention (W)
  • monthly backup retention (M)
  •  yearly backup retention (Y)
  • week of year (WeekOfYear)

If I wanted my monthly (first backup of each month) backup to be copied to long term storage I would invoke that parameter.

Click Configure retention which takes you to the main blade.

So here, I change the PITR capability and make sure I have a monthly in long term storage for 6 months. No need to configure storage accounts and such things because this is managed by Microsoft.


1 thought on “Azure SQL Database and Long-Term Backups

  1. Pingback: Long-Term Backups on Azure SQL Database – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s