Share via

Azure SQL VM | Backup | Discover DBs not discovering anything

Andrew Ford 0 Reputation points
2023-09-26T15:15:41.6966667+00:00

Hello,

I have a Windows VM that was created as a stand-alone server, later SQL 2019 was installed, Azure informed me I could use the new SQL backup features, so I registered it with my vault. I can see the server and SQL instances but I cannot discover any DBs. Auto protect is set to ON.

I have checked SQL permissions and can confirm NT Service\AzureWLBackupPluginSvc has the sysadmin server role.

Why can I not discover any on the DBs hosted on the server?

Azure SQL Database
SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 21,121 Reputation points Microsoft Employee Moderator
    2023-10-03T22:01:21.5733333+00:00

    @Andrew Ford Sorry for the delay in response to your question.

    Auto protect automatically backs up all the databases in the instance, so you won't be able to individually manage the databases. You’ll need to turn this off if you want to discover the databases.

     Azure Backup can automatically protect SQL databases in Azure VM through auto-protect | Azure Blog | Microsoft Azure

    Regards,

    Oury

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.