Azure SQL DB Backups - SSMS

Ricardo Anselmo Oliveira 101 Reputation points

Hello everyone :D

My question is:

  • is there a way to check information, through query, about the backups of all the databases from an Azure SQL DB instance? I know they are automatic, and we can see them through the portal and etc., but i wanted to know if we can get that info directly from SSMS.


Azure SQL Database
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

    Hi @RicardoAnselmoOliveira-7430 Thanks for sharing your query
    msdb exist in Azure SQL managed instance(PAAS) & SQL server versions(On premises/SQL on VM(IAAS))
    msdb database doesn't exist in the Azure SQL database(PAAS)


0 additional answers

Sort by: Most helpful