CurrentBackupStorageRedundancy of my master database on Azure SQL Server
Published Sep 12 2024 06:34 AM 854 Views

Symptoms: 

For your master database you might find different configuration such as Backup Storage Redundancy configured to be Local or Geo

As this is not configurable property you might ask why is my database configured with this value. 

Yochanan_Rachamim_0-1726135348949.png

 

Resolution: 

For master database on Azure SQL Database Server, Microsoft is managing this database as part of the server entity. 

as you cannot change the SLO level (which might be system or system2) for the master database there are other properties that cannot be configured from customer end. 

 

Note that master database is part of the server entity and should not store user data, therefore the only use of master database is to operate the server object. 

 

Backup redundancy is displayed as this is one of the properties shown for database object, however this is irrelevant for master database.

in any case, Microsoft implement mechanisms to keep this database highly available and secure for your database server. 

 

 

 

Co-Authors
Version history
Last update:
‎Sep 12 2024 06:34 AM
Updated by: