[Feature]: Get-AzRecoveryServicesBackupContainer cannot retrieve SQL Always On Availability Group containers

[SQLCanuck]

Description of the new feature

The Get-AzRecoveryServicesBackupContainer cmdlet cannot retrieve SQL Server Always On Availability Group (AG) containers that use the SQLAGWorkLoadContainer type. This creates a gap in automation capabilities for managing SQL AG backups.

The cmdlet currently only supports the following -ContainerType parameter values:

AzureVM
Windows
AzureStorage
AzureVMAppContainer

When retrieving containers, AG containers with the internal type SQLAGWorkLoadContainer are not returned, even though they exist in the vault and are visible in:

Azure REST API responses
The ContainerName property of backup items

# Set vault context
$vault = Get-AzRecoveryServicesVault -Name "your-vault-name"
Set-AzRecoveryServicesVaultContext -Vault $vault

# Attempt to get all containers
$containers = Get-AzRecoveryServicesBackupContainer -ContainerType AzureVMAppContainer

# Result: Only VMAppContainer types returned, no SQLAGWorkLoadContainer types
$containers | Where-Object { $_.Name -like '*SQLAGWorkLoadContainer*' }
# Returns: Nothing

# However, AG backup items exist and reference these containers
$agItems = Get-AzRecoveryServicesBackupItem -BackupManagementType AzureWorkload -WorkloadType MSSQL | 
    Where-Object { $_.ParentType -like '*Availability*' }

$agItems | Select-Object -First 1 | Select-Object ContainerName
# Returns: SQLAGWorkLoadContainer;{GUID}

Proposed implementation details (optional)

No response

[github-actions]

Here are some similar issues that might help you. Please check if they can solve your problem.

• [Feature]: Get-AzRecoveryServicesBackupContainer does not currently support container type sqlagworkloadcontainer #17720

---

Possible solution (Extracted from existing issue, might be incorrect; please verify carefully)

Solution 1:

This is by design as we currently do not include SQLAGs as part of the Get-AzRecoveryServicesBackupContainer command and we currently do it via Get-AzRecoveryServicesBackupprotectableItem command. This is in accordance with the backup REST APIs where we do not get SQL AG containers in Get containers API.

Reference:

• [Feature]: Get-AzRecoveryServicesBackupContainer does not currently support container type sqlagworkloadcontainer #17720 (comment)

Solution 2:

For now we will keep it as is. Will look forward for more customer requirement on this and consider based on that.

Reference:

• [Feature]: Get-AzRecoveryServicesBackupContainer does not currently support container type sqlagworkloadcontainer #17720 (comment)
• [Feature]: Get-AzRecoveryServicesBackupContainer does not currently support container type sqlagworkloadcontainer #17720 (comment)

Powered by issue-sentinel