CODEWITHSUNDEEP
azure-sql-database
GoldenDBA
GoldenDBA

Reputation: 46

How to query Azure SQL backups

I’m looking for documentation on how to run a query against Azure to see when backups were run and what is available to restore from. In an on prem solution this is easy but I have no idea where this info is stored on Azure SQL DB.

Upvotes: 1

Views: 107

Answers (1)

Grant Fritchey
Grant Fritchey

Reputation: 2775

It's not stored in any way. Instead you need to look to the service tier to know how far back you have backup retention. The actual schedule of the backups isn't published because it can vary. After the initial backup is taken, they do differentials and log backups, but you can't see when they happened. You can read more about it here.

Upvotes: 3

Related Questions