Azure SQL DB Backups - SSMS

Ricardo Anselmo Oliveira 101 Reputation points
2022-01-20T14:39:46.937+00:00

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.

TYYYYY :D

Azure SQL Database
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee
    2022-01-20T16:30:09.787+00:00

    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)

    Regards
    Geetha


0 additional answers

Sort by: Most helpful