AzureRM.Sql

This topic displays help topics for the Azure SQL Database Cmdlets.

SQL

Add-AzureRmSqlDatabaseToFailoverGroup

Adds one or more databases to an Azure SQL Database Failover Group.

Add-AzureRmSqlServerKeyVaultKey

Adds a Key Vault key to a SQL server.

Get-AzureRmSqlCapability

Gets SQL Database capabilities for the current subscription.

Get-AzureRmSqlDatabase

Gets one or more databases.

Get-AzureRmSqlDatabaseActivity

Gets the status of database operations.

Get-AzureRmSqlDatabaseAdvisor

Gets one or more Advisors for an Azure SQL Database.

Get-AzureRmSqlDatabaseAuditing

Gets the auditing settings of an Azure SQL database.

Get-AzureRmSqlDatabaseAuditingPolicy

Gets the auditing policy of a database.

Get-AzureRmSqlDatabaseBackupLongTermRetentionPolicy

Gets a database long term retention policy.

Get-AzureRmSqlDatabaseDataMaskingPolicy

Gets the data masking policy for a database.

Get-AzureRmSqlDatabaseDataMaskingRule

Gets the data masking rules from a database.

Get-AzureRmSqlDatabaseExpanded

Gets a database and its expanded property values.

Get-AzureRmSqlDatabaseFailoverGroup

Gets or lists Azure SQL Database Failover Groups.

Get-AzureRmSqlDatabaseGeoBackup

Gets a geo-redundant backup of a database.

Get-AzureRmSqlDatabaseGeoBackupPolicy

Gets a database geo backup policy.

Get-AzureRmSqlDatabaseImportExportStatus

Gets the details of an import or export of an Azure SQL Database.

Get-AzureRmSqlDatabaseIndexRecommendations

Gets the recommended index operations for a server or database.

Get-AzureRmSqlDatabaseRecommendedAction

Gets one or more recommended actions for an Azure SQL Database Advisor.

Get-AzureRmSqlDatabaseReplicationLink

Gets the geo-replication links between an Azure SQL Database and a resource group or SQL Server.

Get-AzureRmSqlDatabaseRestorePoints

Retrieves the distinct restore points from which a SQL Data Warehouse can be restored.

Get-AzureRmSqlDatabaseSecureConnectionPolicy

Gets the secure connection policy for a database.

Get-AzureRmSqlDatabaseThreatDetectionPolicy

Gets the threat detection policy for a database.

Get-AzureRmSqlDatabaseTransparentDataEncryption

Gets the TDE state for a database.

Get-AzureRmSqlDatabaseTransparentDataEncryptionActivity

Gets the progress of a TDE scan of a database.

Get-AzureRmSqlDatabaseUpgradeHint

Gets pricing tier hints for a database.

Get-AzureRmSqlDeletedDatabaseBackup

Gets a deleted database that you can restore.

Get-AzureRmSqlElasticPool

Gets elastic pools and their property values in an Azure SQL Database.

Get-AzureRmSqlElasticPoolActivity

Gets the status of operations on an elastic pool.

Get-AzureRmSqlElasticPoolAdvisor

Gets one or more Advisors for an Azure SQL Elastic Pool.

Get-AzureRmSqlElasticPoolDatabase

Gets elastic databases in an elastic pool and their property values.

Get-AzureRmSqlElasticPoolRecommendation

Gets elastic pool recommendations.

Get-AzureRmSqlElasticPoolRecommendedAction

Gets one or more recommended actions for an Azure SQL Elastic Pool Advisor.

Get-AzureRmSqlServer

Returns information about SQL Database servers.

Get-AzureRmSqlServerActiveDirectoryAdministrator

Gets information about an Azure AD administrator for SQL Server.

Get-AzureRmSqlServerAdvisor

Gets one or more Advisors for an Azure SQL Server.

Get-AzureRmSqlServerAuditing

Gets the auditing settings of an Azure SQL server.

Get-AzureRmSqlServerAuditingPolicy

Gets the auditing policy of a SQL server.

Get-AzureRmSqlServerBackupLongTermRetentionVault

Gets a server long term retention vault.

Get-AzureRmSqlServerCommunicationLink

Gets communication links for elastic database transactions between database servers.

Get-AzureRmSqlServerDisasterRecoveryConfiguration

Gets a database server system recovery configuration.

Get-AzureRmSqlServerDisasterRecoveryConfigurationActivity

Gets activity for a database server system recovery configuration.

Get-AzureRmSqlServerDnsAlias

Gets or lists Azure SQL Server DNS Alias.

Get-AzureRmSqlServerFirewallRule

Gets firewall rules for a SQL Database server.

Get-AzureRmSqlServerKeyVaultKey

Gets a SQL server's Key Vault keys.

Get-AzureRmSqlServerRecommendedAction

Gets one or more recommended actions for an Azure SQL Server Advisor.

Get-AzureRmSqlServerServiceObjective

Gets service objectives for an Azure SQL Database server.

Get-AzureRmSqlServerThreatDetectionPolicy

Gets the threat detection policy for a server.

Get-AzureRmSqlServerTransparentDataEncryptionProtector

Gets the Transparent Data Encryption (TDE) protector

Get-AzureRmSqlServerUpgrade

Gets the status of an Azure SQL Database server upgrade.

Get-AzureRmSqlServerUpgradeHint

Gets pricing tier hints for upgrading an Azure SQL Database server.

Get-AzureRmSqlServerVirtualNetworkRule

Gets or lists Azure SQL Server Virtual Network Rule.

Get-AzureRmSqlSyncAgent

Returns information about Azure SQL Sync Agents.

Get-AzureRmSqlSyncAgentLinkedDatabase

Returns information about SQL Server databases linked by a sync agent.

Get-AzureRmSqlSyncGroup

Returns information about Azure SQL Database Sync Groups.

Get-AzureRmSqlSyncGroupLog

Returns the logs of an Azure SQL Database Sync Group.

Get-AzureRmSqlSyncMember

Returns information about Azure SQL Database Sync Members.

Get-AzureRmSqlSyncSchema

Returns information about the sync schema of a member database or a hub database.

New-AzureRmSqlDatabase

Creates a database or an elastic database.

New-AzureRmSqlDatabaseCopy

Creates a copy of a SQL Database that uses the snapshot at the current time.

New-AzureRmSqlDatabaseDataMaskingRule

Creates a data masking rule for a database.

New-AzureRmSqlDatabaseExport

Exports an Azure SQL Database as a .bacpac file to a storage account.

New-AzureRmSqlDatabaseFailoverGroup

This command creates a new Azure SQL Database Failover Group.

New-AzureRmSqlDatabaseImport

Imports a .bacpac file and create a new database on the server.

New-AzureRmSqlDatabaseSecondary

Creates a secondary database for an existing database and starts data replication.

New-AzureRmSqlElasticPool

Creates an elastic database pool for a SQL Database.

New-AzureRmSqlServer

Creates a SQL Database server.

New-AzureRmSqlServerCommunicationLink

Creates a communication link for elastic database transactions between two SQL Database servers.

New-AzureRmSqlServerDisasterRecoveryConfiguration

Creates a database server system recovery configuration.

New-AzureRmSqlServerDnsAlias

This command creates a new Azure SQL Server DNS Alias.

New-AzureRmSqlServerFirewallRule

Creates a firewall rule for a SQL Database server.

New-AzureRmSqlServerVirtualNetworkRule

Creates an Azure SQL Server Virtual Network Rule.

New-AzureRmSqlSyncAgent

Creates an Azure SQL Sync Agent.

New-AzureRmSqlSyncAgentKey

Creates an Azure SQL Sync Agent Key.

New-AzureRmSqlSyncGroup

Creates an Azure SQL Database Sync Group.

New-AzureRmSqlSyncMember

Creates an Azure SQL Database Sync Member.

Remove-AzureRmSqlDatabase

Removes an Azure SQL database.

Remove-AzureRmSqlDatabaseAuditing

Removes the auditing of a database.

Remove-AzureRmSqlDatabaseDataMaskingRule

Removes a data masking rule from a database.

Remove-AzureRmSqlDatabaseFailoverGroup

Removes an Azure SQL Database Failover Group.

Remove-AzureRmSqlDatabaseFromFailoverGroup

Removes one or more databases from an Azure SQL Database Failover Group.

Remove-AzureRmSqlDatabaseSecondary

Terminates data replication between a SQL Database and the specified secondary database.

Remove-AzureRmSqlDatabaseThreatDetectionPolicy

Removes the threat detection policy from a database.

Remove-AzureRmSqlElasticPool

Deletes an elastic database pool.

Remove-AzureRmSqlServer

Removes an Azure SQL Database server.

Remove-AzureRmSqlServerActiveDirectoryAdministrator

Removes an Azure AD administrator for SQL Server.

Remove-AzureRmSqlServerAuditing

Removes the auditing of a SQL server.

Remove-AzureRmSqlServerCommunicationLink

Deletes a communication link for elastic database transactions between two servers.

Remove-AzureRmSqlServerDisasterRecoveryConfiguration

Removes a SQL database server system recovery configuration.

Remove-AzureRmSqlServerDnsAlias

Removes Azure SQL Server DNS Alias.

Remove-AzureRmSqlServerFirewallRule

Deletes a firewall rule from a SQL Database server.

Remove-AzureRmSqlServerKeyVaultKey

Removes a Key Vault key from a SQL server.

Remove-AzureRmSqlServerThreatDetectionPolicy

Removes the threat detection policy from a server.

Remove-AzureRmSqlServerVirtualNetworkRule

Deletes an Azure SQL Server Virtual Network Rule.

Remove-AzureRmSqlSyncAgent

Removes an Azure SQL Sync Agent.

Remove-AzureRmSqlSyncGroup

Removes an Azure SQL Database Sync Group.

Remove-AzureRmSqlSyncMember

Removes an Azure SQL Database Sync Member.

Restore-AzureRmSqlDatabase

Restores a SQL database.

Resume-AzureRmSqlDatabase

Resumes a SQL Data Warehouse database.

Set-AzureRmSqlDatabase

Sets properties for a database, or moves an existing database into an elastic pool.

Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus

Modifies auto execute status of an Azure SQL Database Advisor.

Set-AzureRmSqlDatabaseAuditing

Changes the auditing settings for an Azure SQL database.

Set-AzureRmSqlDatabaseAuditingPolicy

Sets the auditing policy for a database.

Set-AzureRmSqlDatabaseBackupLongTermRetentionPolicy

Sets a server long term retention policy.

Set-AzureRmSqlDatabaseDataMaskingPolicy

Sets data masking for a database.

Set-AzureRmSqlDatabaseDataMaskingRule

Sets the properties of a data masking rule for a database.

Set-AzureRmSqlDatabaseFailoverGroup

Modifies the configuration of an Azure SQL Database Failover Group.

Set-AzureRmSqlDatabaseGeoBackupPolicy

Sets a database geo backup policy.

Set-AzureRmSqlDatabaseRecommendedActionState

Updates the state of an Azure SQL Database recommended action.

Set-AzureRmSqlDatabaseSecondary

Switches a secondary database to be primary in order to initiate failover.

Set-AzureRmSqlDatabaseThreatDetectionPolicy

Sets a threat detection policy on a database.

Set-AzureRmSqlDatabaseTransparentDataEncryption

Modifies TDE property for a database.

Set-AzureRmSqlElasticPool

Modifies properties of an elastic database pool in Azure SQL Database.

Set-AzureRmSqlElasticPoolAdvisorAutoExecuteStatus

Updates auto execute status of an Azure SQL Elastic Pool Advisor.

Set-AzureRmSqlElasticPoolRecommendedActionState

Updates the state of an Azure SQL Elastic Pool recommended action.

Set-AzureRmSqlServer

Modifies properties of a SQL Database server.

Set-AzureRmSqlServerActiveDirectoryAdministrator

Provisions an Azure AD administrator for SQL Server.

Set-AzureRmSqlServerAdvisorAutoExecuteStatus

Updates the auto execute status of an Azure SQL Server Advisor.

Set-AzureRmSqlServerAuditing

Changes the auditing settings of an Azure SQL server.

Set-AzureRmSqlServerAuditingPolicy

Changes the auditing policy of a SQL Database server.

Set-AzureRmSqlServerBackupLongTermRetentionVault

Sets a server long term retention vault.

Set-AzureRmSqlServerDisasterRecoveryConfiguration

Modifies a database server recovery configuration.

Set-AzureRmSqlServerDnsAlias

Modifies the server to which Azure SQL Server DNS Alias is pointing

Set-AzureRmSqlServerFirewallRule

Modifies a firewall rule in Azure SQL Database server.

Set-AzureRmSqlServerRecommendedActionState

Updates the state of an Azure SQL Server recommended action.

Set-AzureRmSqlServerThreatDetectionPolicy

Sets a threat detection policy on a server.

Set-AzureRmSqlServerTransparentDataEncryptionProtector

Sets the Transparent Data Encryption (TDE) protector for a SQL server.

Set-AzureRmSqlServerVirtualNetworkRule

Modifies the configuration of an Azure SQL Server Virtual Network Rule.

Start-AzureRmSqlDatabaseExecuteIndexRecommendation

Starts the workflow that runs a recommended index operation.

Start-AzureRmSqlServerUpgrade

Starts the upgrade of a SQL Database server.

Start-AzureRmSqlSyncGroupSync

Starts a sync group synchronization.

Stop-AzureRmSqlDatabaseActivity

Cancels the asynchronous updateslo operation on the database.

Stop-AzureRmSqlDatabaseExecuteIndexRecommendation

Stops the workflow that runs a recommended index operation.

Stop-AzureRmSqlServerUpgrade

Stops the upgrade of a SQL Database server.

Stop-AzureRmSqlSyncGroupSync

Stops a sync group synchronization.

Suspend-AzureRmSqlDatabase

Suspends a SQL Data Warehouse database.

Switch-AzureRmSqlDatabaseFailoverGroup

Executes a failover of an Azure SQL Database Failover Group.

Update-AzureRmSqlSyncGroup

Updates an Azure SQL Database Sync Group.

Update-AzureRmSqlSyncMember

Updates an Azure SQL Database Sync Member.

Update-AzureRmSqlSyncSchema

Update the sync schema for a sync member database or a sync hub database.

Use-AzureRmSqlServerAuditingPolicy

Specifies that a database uses the auditing policy of its host server.