I don't have "Long-Term Backup Retention" in my list of properties on the left side for my Azure SQL database or database server even though I have added a "Backup Service Vault" in the same data center with the same resource group. I am not able to setup the SQL backup to long term retention steps from Microsoft. How can I get "Long-Term Backup Retention" to be available for my v12 database?
2 Answers
0
votes
How do I enable Long-Term Retention? To configure long-term backup retention for a database:
- Create an Azure Recovery Services vault in the same region, subscription, and resource group as your SQL Database server.
- Register the server to the vault
- Create an Azure Recovery Services Protection Policy
- Apply the protection policy to the databases that require long-term backup retention
Taken from: https://azure.microsoft.com/en-us/documentation/articles/sql-database-long-term-retention/
0
votes
Please have a look at the following article for a Step by Step process for configuring and saving the Long-term retention plan for a given SQL Server and it's databases and save those backups in a Azure Backup and Recovery Services vault.
Please note that you can see the backups after a week.
Thanks, Prawin
