Azure SQL and Azure SQL Managed Instance – Backup retention polices Loading …

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

We have been working recently on a case where Azure portal was not able to show Backup "Retention Policies" and it was showing all the time "Loading" message. 

 

Palomag_MSFT_0-1664273557960.png

 

The source of this behaviour is that he was created some databases using non supported characters.

 

Palomag_MSFT_2-1664273987732.png

 

When you try to create a new database (*) using Azure Portal using non supported characters, you will see an error indicating characters that you cannot use on the database name.  

 

Palomag_MSFT_3-1664274169635.png

 

But if you use SSMS tool, it doesn't include these characters cheeking and it will not avoid you to use these non-supported characters on the database name. 

 

After renaming these databases and wait few minutes to allow Azure Resource Manager refresh cache. Retention policies are showed correctly.

 

Palomag_MSFT_4-1664274907978.png

 

(*) You can reproduce same behaviour for Azure SQL and Managed Instance Databases.

 

For additional information about database identifiers, you can review this public document. 

https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-ver16

 

Regards, Paloma.-

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.