Secure Azure SQL Server Backups Using Managed Identities

Posted on April 23, 2025 by blobeater

I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs). If you recall you would use the storage key ( ideally not) or a SAS token, from there you would create a SQL credential that is bound to the SAS token (as a secret). Lots of moving parts especially when it comes to rotation time. So now, if you are on the newer versions of SQL server (SQL Server 2022 Cumulative Update 17 ) start thinking about backups via managed identities.

Continue reading →

Azure SQL Database and Long-Term Backups

Posted on February 2, 2021 by blobeater

There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server.

As you can see, by default we have 7 days retention to allow for PITR – Point In Time Recovery, anything longer you will need to setup long term retention.

Continue reading →

Backups for Azure SQL Virtual Machines

Posted on September 16, 2020 by blobeater

When it comes to database backups for IaaS based Azure SQL Servers you have 3 options.

Continue reading →

Azure SQL Database and Backups

Posted on July 14, 2020 by blobeater

Question, can you take a built-in backup ( a backup that Microsoft takes as part of the service) and create a new database from it on a NEW server in a different region?

Let’s find out.

Continue reading →