Posted September 27, 20222 yr 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. The source of this behaviour is that he was created some databases using non supported characters. 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. 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. (*) 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.- Continue reading...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.