Az.Sql

Author(s)

• Microsoft Corporation

Tags

Azure ResourceManager ARM Sql Database

Cmdlets

Add-AzSqlDatabaseToFailoverGroup Add-AzSqlElasticJobStep Add-AzSqlElasticJobTarget Add-AzSqlInstanceKeyVaultKey Add-AzSqlManagedInstanceTransparentDataEncryptionCertificate Add-AzSqlServerKeyVaultKey Add-AzSqlServerTransparentDataEncryptionCertificate Clear-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlDatabaseVulnerabilityAssessmentSetting Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Clear-AzSqlInstanceVulnerabilityAssessmentSetting Clear-AzSqlServerVulnerabilityAssessmentSetting Complete-AzSqlInstanceDatabaseCopy Complete-AzSqlInstanceDatabaseLogReplay Complete-AzSqlInstanceDatabaseMove Convert-AzSqlDatabaseVulnerabilityAssessmentScan Convert-AzSqlInstanceDatabaseVulnerabilityAssessmentScan Copy-AzSqlDatabaseLongTermRetentionBackup Copy-AzSqlInstanceDatabase Disable-AzSqlDatabaseLedgerDigestUpload Disable-AzSqlDatabaseSensitivityRecommendation Disable-AzSqlInstanceActiveDirectoryOnlyAuthentication Disable-AzSqlInstanceAdvancedDataSecurity Disable-AzSqlInstanceDatabaseLedgerDigestUpload Disable-AzSqlInstanceDatabaseSensitivityRecommendation Disable-AzSqlServerActiveDirectoryOnlyAuthentication Disable-AzSqlServerAdvancedDataSecurity Enable-AzSqlDatabaseLedgerDigestUpload Enable-AzSqlDatabaseSensitivityRecommendation Enable-AzSqlInstanceActiveDirectoryOnlyAuthentication Enable-AzSqlInstanceAdvancedDataSecurity Enable-AzSqlInstanceDatabaseLedgerDigestUpload Enable-AzSqlInstanceDatabaseSensitivityRecommendation Enable-AzSqlServerActiveDirectoryOnlyAuthentication Enable-AzSqlServerAdvancedDataSecurity Get-AzSqlCapability Get-AzSqlDatabase Get-AzSqlDatabaseActivity Get-AzSqlDatabaseAdvancedThreatProtectionSetting Get-AzSqlDatabaseAdvisor Get-AzSqlDatabaseAudit Get-AzSqlDatabaseBackupLongTermRetentionPolicy Get-AzSqlDatabaseBackupShortTermRetentionPolicy Get-AzSqlDatabaseDataMaskingPolicy Get-AzSqlDatabaseDataMaskingRule Get-AzSqlDatabaseExpanded Get-AzSqlDatabaseFailoverGroup Get-AzSqlDatabaseGeoBackup Get-AzSqlDatabaseGeoBackupPolicy Get-AzSqlDatabaseImportExportStatus Get-AzSqlDatabaseIndexRecommendation Get-AzSqlDatabaseInstanceFailoverGroup Get-AzSqlDatabaseLedgerDigestUpload Get-AzSqlDatabaseLongTermRetentionBackup Get-AzSqlDatabaseRecommendedAction Get-AzSqlDatabaseReplicationLink Get-AzSqlDatabaseRestorePoint Set-AzSqlDatabaseReplicationLink Get-AzSqlDatabaseSensitivityClassification Get-AzSqlDatabaseSensitivityRecommendation Get-AzSqlDatabaseTransparentDataEncryption Get-AzSqlDatabaseUpgradeHint Get-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord Get-AzSqlDatabaseVulnerabilityAssessmentSetting Get-AzSqlDeletedDatabaseBackup Get-AzSqlDeletedInstanceDatabaseBackup Get-AzSqlDeletedServer Get-AzSqlElasticJob Get-AzSqlElasticJobAgent Get-AzSqlElasticJobCredential Get-AzSqlElasticJobExecution Get-AzSqlElasticJobPrivateEndpoint Get-AzSqlElasticJobStep Get-AzSqlElasticJobStepExecution Get-AzSqlElasticJobTargetExecution Get-AzSqlElasticJobTargetGroup Get-AzSqlElasticPool Get-AzSqlElasticPoolActivity Get-AzSqlElasticPoolAdvisor Get-AzSqlElasticPoolDatabase Get-AzSqlElasticPoolRecommendation Get-AzSqlElasticPoolRecommendedAction Get-AzSqlInstance Get-AzSqlInstanceActiveDirectoryAdministrator Get-AzSqlInstanceActiveDirectoryOnlyAuthentication Get-AzSqlInstanceAdvancedDataSecurityPolicy Get-AzSqlInstanceAdvancedThreatProtectionSetting Get-AzSqlInstanceDatabase Get-AzSqlInstanceDatabaseAdvancedThreatProtectionSetting Get-AzSqlInstanceDatabaseBackupLongTermRetentionPolicy Get-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy Get-AzSqlInstanceDatabaseCopyOperation Get-AzSqlInstanceDatabaseGeoBackup Get-AzSqlInstanceDatabaseLedgerDigestUpload Get-AzSqlInstanceDatabaseLogReplay Get-AzSqlInstanceDatabaseLongTermRetentionBackup Get-AzSqlInstanceDatabaseMoveOperation Get-AzSqlInstanceDatabaseSensitivityClassification Get-AzSqlInstanceDatabaseSensitivityRecommendation Get-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlInstanceDatabaseVulnerabilityAssessmentScanRecord Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Get-AzSqlInstanceDtc Get-AzSqlInstanceEndpointCertificate Get-AzSqlInstanceKeyVaultKey Get-AzSqlInstanceLink Get-AzSqlInstanceOperation Get-AzSqlInstancePool Get-AzSqlInstancePoolUsage Get-AzSqlInstanceServerTrustCertificate Get-AzSqlInstanceStartStopSchedule Get-AzSqlInstanceTransparentDataEncryptionProtector Get-AzSqlInstanceVulnerabilityAssessmentSetting Get-AzSqlServer Get-AzSqlServerActiveDirectoryAdministrator Get-AzSqlServerActiveDirectoryOnlyAuthentication Get-AzSqlServerAdvancedDataSecurityPolicy Get-AzSqlServerAdvancedThreatProtectionSetting Get-AzSqlServerAdvisor Get-AzSqlServerAudit Get-AzSqlServerCommunicationLink Get-AzSqlServerConfigurationOption Get-AzSqlServerDisasterRecoveryConfiguration Get-AzSqlServerDisasterRecoveryConfigurationActivity Get-AzSqlServerDnsAlias Get-AzSqlServerFirewallRule Get-AzSqlServerIpv6FirewallRule Get-AzSqlServerKeyVaultKey Get-AzSqlServerMSSupportAudit Get-AzSqlServerOutboundFirewallRule Get-AzSqlServerRecommendedAction Get-AzSqlServerServiceObjective Get-AzSqlServerTransparentDataEncryptionProtector Get-AzSqlServerTrustGroup Get-AzSqlServerUpgradeHint Get-AzSqlServerVirtualNetworkRule Get-AzSqlServerVulnerabilityAssessmentSetting Get-AzSqlSyncAgent Get-AzSqlSyncAgentLinkedDatabase Get-AzSqlSyncGroup Get-AzSqlSyncGroupLog Get-AzSqlSyncMember Get-AzSqlSyncSchema Get-AzSqlVirtualCluster Invoke-AzSqlDatabaseFailover Start-AzSqlInstanceLinkFailover Invoke-AzSqlDatabaseTransparentDataEncryptionProtectorRevalidation Invoke-AzSqlDatabaseTransparentDataEncryptionProtectorRevert Invoke-AzSqlElasticPoolFailover Invoke-AzSqlInstanceFailover Invoke-AzSqlInstanceExternalGovernanceStatusRefresh Invoke-AzSqlInstanceTransparentDataEncryptionProtectorRevalidation Invoke-AzSqlServerExternalGovernanceStatusRefresh Invoke-AzSqlServerTransparentDataEncryptionProtectorRevalidation Lock-AzSqlDatabaseLongTermRetentionBackupImmutability Move-AzSqlInstanceDatabase New-AzSqlDatabase New-AzSqlDatabaseCopy New-AzSqlDatabaseDataMaskingRule New-AzSqlDatabaseExport New-AzSqlDatabaseFailoverGroup New-AzSqlDatabaseImport New-AzSqlDatabaseInstanceFailoverGroup New-AzSqlDatabaseRestorePoint New-AzSqlDatabaseSecondary New-AzSqlElasticJob New-AzSqlElasticJobAgent New-AzSqlElasticJobCredential New-AzSqlElasticJobPrivateEndpoint New-AzSqlElasticJobTargetGroup New-AzSqlElasticPool New-AzSqlInstance New-AzSqlInstanceDatabase New-AzSqlInstanceLink New-AzSqlInstancePool New-AzSqlInstanceScheduleItem New-AzSqlInstanceServerTrustCertificate New-AzSqlInstanceStartStopSchedule New-AzSqlServer New-AzSqlServerCommunicationLink New-AzSqlServerDisasterRecoveryConfiguration New-AzSqlServerDnsAlias New-AzSqlServerFirewallRule New-AzSqlServerIpv6FirewallRule New-AzSqlServerOutboundFirewallRule New-AzSqlServerTrustGroup New-AzSqlServerVirtualNetworkRule New-AzSqlSyncAgent New-AzSqlSyncAgentKey New-AzSqlSyncGroup New-AzSqlSyncMember Remove-AzSqlDatabase Remove-AzSqlDatabaseAudit Remove-AzSqlDatabaseDataMaskingRule Remove-AzSqlDatabaseFailoverGroup Remove-AzSqlDatabaseFromFailoverGroup Remove-AzSqlDatabaseInstanceFailoverGroup Remove-AzSqlDatabaseLongTermRetentionBackup Remove-AzSqlDatabaseLongTermRetentionBackupImmutability Remove-AzSqlDatabaseLongTermRetentionBackupLegalHold Remove-AzSqlDatabaseRestorePoint Remove-AzSqlDatabaseSecondary Remove-AzSqlDatabaseSensitivityClassification Remove-AzSqlElasticJob Remove-AzSqlElasticJobAgent Remove-AzSqlElasticJobCredential Remove-AzSqlElasticJobPrivateEndpoint Remove-AzSqlElasticJobStep Remove-AzSqlElasticJobTarget Remove-AzSqlElasticJobTargetGroup Remove-AzSqlElasticPool Remove-AzSqlInstance Remove-AzSqlInstanceActiveDirectoryAdministrator Remove-AzSqlInstanceDatabase Remove-AzSqlInstanceDatabaseLongTermRetentionBackup Remove-AzSqlInstanceDatabaseSensitivityClassification Remove-AzSqlInstanceKeyVaultKey Remove-AzSqlInstanceLink Remove-AzSqlInstancePool Remove-AzSqlInstanceServerTrustCertificate Remove-AzSqlInstanceStartStopSchedule Remove-AzSqlServer Remove-AzSqlServerActiveDirectoryAdministrator Remove-AzSqlServerAudit Remove-AzSqlServerCommunicationLink Remove-AzSqlServerDisasterRecoveryConfiguration Remove-AzSqlServerDnsAlias Remove-AzSqlServerFirewallRule Remove-AzSqlServerIpv6FirewallRule Remove-AzSqlServerKeyVaultKey Remove-AzSqlServerMSSupportAudit Remove-AzSqlServerOutboundFirewallRule Remove-AzSqlServerTrustGroup Remove-AzSqlServerVirtualNetworkRule Remove-AzSqlSyncAgent Remove-AzSqlSyncGroup Remove-AzSqlSyncMember Remove-AzSqlVirtualCluster Restore-AzSqlDatabase Restore-AzSqlInstanceDatabase Restore-AzSqlServer Resume-AzSqlDatabase Set-AzSqlDatabase Set-AzSqlDatabaseAdvisorAutoExecuteStatus Set-AzSqlDatabaseAudit Set-AzSqlDatabaseBackupLongTermRetentionPolicy Set-AzSqlDatabaseBackupShortTermRetentionPolicy Set-AzSqlDatabaseDataMaskingPolicy Set-AzSqlDatabaseDataMaskingRule Set-AzSqlDatabaseFailoverGroup Set-AzSqlDatabaseGeoBackupPolicy Set-AzSqlDatabaseInstanceFailoverGroup Set-AzSqlDatabaseRecommendedActionState Set-AzSqlDatabaseSecondary Set-AzSqlDatabaseSensitivityClassification Set-AzSqlDatabaseTransparentDataEncryption Set-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Set-AzSqlElasticJob Set-AzSqlElasticJobAgent Set-AzSqlElasticJobCredential Set-AzSqlElasticJobStep Set-AzSqlElasticPool Set-AzSqlElasticPoolAdvisorAutoExecuteStatus Set-AzSqlElasticPoolRecommendedActionState Set-AzSqlInstance Set-AzSqlInstanceActiveDirectoryAdministrator Set-AzSqlInstanceDatabase Set-AzSqlInstanceDatabaseBackupLongTermRetentionPolicy Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy Set-AzSqlInstanceDatabaseSensitivityClassification Set-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Set-AzSqlInstanceDtc Set-AzSqlInstancePool Set-AzSqlInstanceTransparentDataEncryptionProtector Set-AzSqlDatabaseLongTermRetentionBackupLegalHold Set-AzSqlServer Set-AzSqlServerActiveDirectoryAdministrator Set-AzSqlServerAdvisorAutoExecuteStatus Set-AzSqlServerAudit Set-AzSqlServerConfigurationOption Set-AzSqlServerDisasterRecoveryConfiguration Set-AzSqlServerDnsAlias Set-AzSqlServerFirewallRule Set-AzSqlServerIpv6FirewallRule Set-AzSqlServerMSSupportAudit Set-AzSqlServerRecommendedActionState Set-AzSqlServerTransparentDataEncryptionProtector Set-AzSqlServerVirtualNetworkRule Start-AzSqlDatabaseExecuteIndexRecommendation Start-AzSqlDatabaseVulnerabilityAssessmentScan Start-AzSqlElasticJob Start-AzSqlInstance Start-AzSqlInstanceDatabaseLogReplay Start-AzSqlInstanceDatabaseVulnerabilityAssessmentScan Start-AzSqlSyncGroupSync Stop-AzSqlDatabaseActivity Stop-AzSqlDatabaseExecuteIndexRecommendation Stop-AzSqlElasticJob Stop-AzSqlElasticPoolActivity Stop-AzSqlInstance Stop-AzSqlInstanceDatabaseCopy Stop-AzSqlInstanceDatabaseLogReplay Stop-AzSqlInstanceDatabaseMove Stop-AzSqlInstanceOperation Stop-AzSqlSyncGroupSync Suspend-AzSqlDatabase Switch-AzSqlDatabaseFailoverGroup Switch-AzSqlDatabaseInstanceFailoverGroup Update-AzSqlDatabaseAdvancedThreatProtectionSetting Update-AzSqlDatabaseLongTermRetentionBackup Update-AzSqlDatabaseVulnerabilityAssessmentSetting Update-AzSqlInstanceAdvancedThreatProtectionSetting Update-AzSqlInstanceDatabaseAdvancedThreatProtectionSetting Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Update-AzSqlInstanceLink Update-AzSqlInstanceVulnerabilityAssessmentSetting Update-AzSqlServerAdvancedThreatProtectionSetting Update-AzSqlServerVulnerabilityAssessmentSetting Update-AzSqlSyncGroup Update-AzSqlSyncMember Update-AzSqlSyncSchema

PSEditions

Core Desktop

Dependencies

• • Az.Accounts (>= 5.4.0)

Release Notes

* Fixed error handling in Az.Sql cmdlets that inherit from 'AzureSqlCmdletBase' to surface descriptive error messages instead of generic 'Operation returned an invalid status code' when API calls fail. This restores meaningful error details such as Azure Policy violation messages.