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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,784 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
    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 Answers by the question author, which helps users to know the answer solved the author's problem.