CurrentBackupStorageRedundancy of my master database on Azure SQL Server

  • Thread starter Thread starter Yochanan_Rachamim
  • Start date Start date
Y

Yochanan_Rachamim

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.

Continue reading...
 
Back
Top