Does Get-AzSqlDatabase pull info from a SQL instance on a Azure VM ? I get this when i try.

Narasimhan, Ranga 26 Reputation points
2023-01-05T16:04:40.077+00:00

Get-AzSqlDatabase : Can not perform requested operation on nested resource. Parent resource 'SQLInstance' not found.
At S:\BackupStatus\All SQLServers.ps1:13 char:9

  • Get-AzSqlDatabase -ResourceGroupName $server.ResourceGroupNam ...
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • CategoryInfo : CloseError: (:) [Get-AzSqlDatabase], CloudException
  • FullyQualifiedErrorId : Microsoft.Azure.Commands.Sql.Database.Cmdlet.GetAzureSqlDatabase
SQL Server on Azure Virtual Machines
0 comments No comments
{count} votes

Accepted answer
  1. TP 83,731 Reputation points
    2023-01-05T19:29:01.587+00:00

    Hi,

    Get-AzSqlDatabase is for Azure SQL Database. It is not for SQL Server running in an Azure VM.

    Please click Accept Answer if the above answered your question.

    Thanks.

    -TP

    0 comments No comments

0 additional answers

Sort by: Most helpful