(10 Years):Azure SQL Database Long-term backup retention(Preview)

In my previous organization has asked me how can retain the Azure SQL (PasS) services Backup for 10 years and i was searching that option but didn’t get .

But now that is possible Through  Long-term backup retention(Preview) to retain your Azure SQL Database backup for 10 years with the backup vault that option is in Preview and lets how we can configure the Azure SQL Database backup for 10 years with recovery Vault  .

Step-1 :  Identification Of SQL Database 

  • Click on the SQL Database
  • Select the Azure SQL Server Name

SQL3

Step:2 Long Term Backup Retention Configuration.

  • Go to Settings
  • Select the Long Term Backup Retention Tab

SQL4

  • Select the Preview Items
  • Accept the term and Condition .
  • Select the Database you want retain more than 1 years.

SQL5

Step :3 Long Term Backup Configuration 

  • Select the Backup Recovery Vault if you have created
  • If you don’t have recovery Vault ,Please create one Recovery Vault.
  • Select the Backup Retention for 1 year to 10 Years.
  • Click on

SQL6

Save the Configuration and you SQL Database backup is configured for 10 years.

SQL7

SQL Backup is enabled for 10 years.

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s