Azure​RM.​Sql

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

SQL

Add-​Azure​Rm​Sql​Database​To​Failover​Group

{{Fill in the Synopsis}}

Add-​Azure​Rm​Sql​Server​Key​Vault​Key

Adds a Key Vault key to a SQL server.

Get-​Azure​Rm​Sql​Capability

Gets SQL Database capabilities for the current subscription.

Get-​Azure​Rm​Sql​Database

Gets one or more databases.

Get-​Azure​Rm​Sql​Database​Activity

Gets the status of moving elastic databases.

Get-​Azure​Rm​Sql​Database​Advisor

Gets one or more Advisors for an Azure SQL Database.

Get-​Azure​Rm​Sql​Database​Auditing​Policy

Gets the auditing policy of a database.

Get-​Azure​Rm​Sql​Database​Backup​Long​Term​Retention​Policy

Gets a database long term retention policy.

Get-​Azure​Rm​Sql​Database​Data​Masking​Policy

Gets the data masking policy for a database.

Get-​Azure​Rm​Sql​Database​Data​Masking​Rule

Gets the data masking rules from a database.

Get-​Azure​Rm​Sql​Database​Expanded

Gets a database and its expanded property values.

Get-​Azure​Rm​Sql​Database​Failover​Group

{{Fill in the Synopsis}}

Get-​Azure​Rm​Sql​Database​Geo​Backup

Gets a geo-redundant backup of a database.

Get-​Azure​Rm​Sql​Database​Geo​Backup​Policy

Gets a database geo backup policy.

Get-​Azure​Rm​Sql​Database​Import​Export​Status

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

Get-​Azure​Rm​Sql​Database​Index​Recommendations

Gets the recommended index operations for a server or database.

Get-​Azure​Rm​Sql​Database​Recommended​Action

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

Get-​Azure​Rm​Sql​Database​Replication​Link

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

Get-​Azure​Rm​Sql​Database​Restore​Points

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

Get-​Azure​Rm​Sql​Database​Secure​Connection​Policy

Gets the secure connection policy for a database.

Get-​Azure​Rm​Sql​Database​Threat​Detection​Policy

Gets the threat detection policy for a database.

Get-​Azure​Rm​Sql​Database​Transparent​Data​Encryption

Gets the TDE state for a database.

Get-​Azure​Rm​Sql​Database​Transparent​Data​Encryption​Activity

Gets the progress of a TDE scan of a database.

Get-​Azure​Rm​Sql​Database​Upgrade​Hint

Gets pricing tier hints for a database.

Get-​Azure​Rm​Sql​Deleted​Database​Backup

Gets a deleted database that you can restore.

Get-​Azure​Rm​Sql​Elastic​Pool

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

Get-​Azure​Rm​Sql​Elastic​Pool​Activity

Gets the status of operations on an elastic pool.

Get-​Azure​Rm​Sql​Elastic​Pool​Advisor

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

Get-​Azure​Rm​Sql​Elastic​Pool​Database

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

Get-​Azure​Rm​Sql​Elastic​Pool​Recommendation

Gets elastic pool recommendations.

Get-​Azure​Rm​Sql​Elastic​Pool​Recommended​Action

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

Get-​Azure​Rm​Sql​Server

Returns information about SQL Database servers.

Get-​Azure​Rm​Sql​Server​Active​Directory​Administrator

Gets information about an Azure AD administrator for SQL Server.

Get-​Azure​Rm​Sql​Server​Advisor

Gets one or more Advisors for an Azure SQL Server.

Get-​Azure​Rm​Sql​Server​Auditing​Policy

Gets the auditing policy of a SQL server.

Get-​Azure​Rm​Sql​Server​Backup​Long​Term​Retention​Vault

Gets a server long term retention vault.

Get-​Azure​Rm​Sql​Server​Communication​Link

Gets communication links for elastic database transactions between database servers.

Get-​Azure​Rm​Sql​Server​Disaster​Recovery​Configuration

Gets a database server system recovery configuration.

Get-​Azure​Rm​Sql​Server​Disaster​Recovery​Configuration​Activity

Gets activity for a database server system recovery configuration.

Get-​Azure​Rm​Sql​Server​Firewall​Rule

Gets firewall rules for a SQL Database server.

Get-​Azure​Rm​Sql​Server​Key​Vault​Key

Gets a SQL server's Key Vault keys.

Get-​Azure​Rm​Sql​Server​Recommended​Action

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

Get-​Azure​Rm​Sql​Server​Service​Objective

Gets service objectives for an Azure SQL Database server.

Get-​Azure​Rm​Sql​Server​Threat​Detection​Policy

Gets the threat detection policy for a server.

Get-​Azure​Rm​Sql​Server​Transparent​Data​Encryption​Protector

Gets the Transparent Data Encryption (TDE) protector

Get-​Azure​Rm​Sql​Server​Upgrade

Gets the status of an Azure SQL Database server upgrade.

Get-​Azure​Rm​Sql​Server​Upgrade​Hint

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

New-​Azure​Rm​Sql​Database

Creates a database or an elastic database.

New-​Azure​Rm​Sql​Database​Copy

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

New-​Azure​Rm​Sql​Database​Data​Masking​Rule

Creates a data masking rule for a database.

New-​Azure​Rm​Sql​Database​Export

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

New-​Azure​Rm​Sql​Database​Failover​Group

{{Fill in the Synopsis}}

New-​Azure​Rm​Sql​Database​Import

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

New-​Azure​Rm​Sql​Database​Secondary

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

New-​Azure​Rm​Sql​Elastic​Pool

Creates an elastic database pool for a SQL Database.

New-​Azure​Rm​Sql​Server

Creates a SQL Database server.

New-​Azure​Rm​Sql​Server​Communication​Link

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

New-​Azure​Rm​Sql​Server​Disaster​Recovery​Configuration

Creates a database server system recovery configuration.

New-​Azure​Rm​Sql​Server​Firewall​Rule

Creates a firewall rule for a SQL Database server.

Remove-​Azure​Rm​Sql​Database

Removes an Azure SQL database.

Remove-​Azure​Rm​Sql​Database​Auditing

Removes the auditing of a database.

Remove-​Azure​Rm​Sql​Database​Data​Masking​Rule

Removes a data masking rule from a database.

Remove-​Azure​Rm​Sql​Database​Failover​Group

{{Fill in the Synopsis}}

Remove-​Azure​Rm​Sql​Database​From​Failover​Group

{{Fill in the Synopsis}}

Remove-​Azure​Rm​Sql​Database​Secondary

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

Remove-​Azure​Rm​Sql​Database​Threat​Detection​Policy

Removes the threat detection policy from a database.

Remove-​Azure​Rm​Sql​Elastic​Pool

Deletes an elastic database pool.

Remove-​Azure​Rm​Sql​Server

Removes an Azure SQL Database server.

Remove-​Azure​Rm​Sql​Server​Active​Directory​Administrator

Removes an Azure AD administrator for SQL Server.

Remove-​Azure​Rm​Sql​Server​Auditing

Removes the auditing of a SQL server.

Remove-​Azure​Rm​Sql​Server​Communication​Link

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

Remove-​Azure​Rm​Sql​Server​Disaster​Recovery​Configuration

Removes a SQL database server system recovery configuration.

Remove-​Azure​Rm​Sql​Server​Firewall​Rule

Deletes a firewall rule from a SQL Database server.

Remove-​Azure​Rm​Sql​Server​Key​Vault​Key

Removes a Key Vault key from a SQL server.

Remove-​Azure​Rm​Sql​Server​Threat​Detection​Policy

Removes the threat detection policy from a server.

Restore-​Azure​Rm​Sql​Database

Restores a SQL database.

Resume-​Azure​Rm​Sql​Database

Resumes a SQL Data Warehouse database.

Set-​Azure​Rm​Sql​Database

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

Set-​Azure​Rm​Sql​Database​Advisor​Auto​Execute​Status

Modifies auto execute status of an Azure SQL Database Advisor.

Set-​Azure​Rm​Sql​Database​Auditing​Policy

Sets the auditing policy for a database.

Set-​Azure​Rm​Sql​Database​Backup​Long​Term​Retention​Policy

Sets a server long term retention policy.

Set-​Azure​Rm​Sql​Database​Data​Masking​Policy

Sets data masking for a database.

Set-​Azure​Rm​Sql​Database​Data​Masking​Rule

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

Set-​Azure​Rm​Sql​Database​Failover​Group

{{Fill in the Synopsis}}

Set-​Azure​Rm​Sql​Database​Geo​Backup​Policy

Sets a database geo backup policy.

Set-​Azure​Rm​Sql​Database​Recommended​Action​State

Updates the state of an Azure SQL Database recommended action.

Set-​Azure​Rm​Sql​Database​Secondary

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

Set-​Azure​Rm​Sql​Database​Threat​Detection​Policy

Sets a threat detection policy on a database.

Set-​Azure​Rm​Sql​Database​Transparent​Data​Encryption

Modifies TDE property for a database.

Set-​Azure​Rm​Sql​Elastic​Pool

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

Set-​Azure​Rm​Sql​Elastic​Pool​Advisor​Auto​Execute​Status

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

Set-​Azure​Rm​Sql​Elastic​Pool​Recommended​Action​State

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

Set-​Azure​Rm​Sql​Server

Modifies properties of a SQL Database server.

Set-​Azure​Rm​Sql​Server​Active​Directory​Administrator

Provisions an Azure AD administrator for SQL Server.

Set-​Azure​Rm​Sql​Server​Advisor​Auto​Execute​Status

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

Set-​Azure​Rm​Sql​Server​Auditing​Policy

Changes the auditing policy of a SQL Database server.

Set-​Azure​Rm​Sql​Server​Backup​Long​Term​Retention​Vault

Sets a server long term retention vault.

Set-​Azure​Rm​Sql​Server​Disaster​Recovery​Configuration

Modifies a database server recovery configuration.

Set-​Azure​Rm​Sql​Server​Firewall​Rule

Modifies a firewall rule in Azure SQL Database server.

Set-​Azure​Rm​Sql​Server​Recommended​Action​State

Updates the state of an Azure SQL Server recommended action.

Set-​Azure​Rm​Sql​Server​Threat​Detection​Policy

Sets a threat detection policy on a server.

Set-​Azure​Rm​Sql​Server​Transparent​Data​Encryption​Protector

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

Start-​Azure​Rm​Sql​Database​Execute​Index​Recommendation

Starts the workflow that runs a recommended index operation.

Start-​Azure​Rm​Sql​Server​Upgrade

Starts the upgrade of a SQL Database server.

Stop-​Azure​Rm​Sql​Database​Execute​Index​Recommendation

Stops the workflow that runs a recommended index operation.

Stop-​Azure​Rm​Sql​Server​Upgrade

Stops the upgrade of a SQL Database server.

Suspend-​Azure​Rm​Sql​Database

Suspends a SQL Data Warehouse database.

Switch-​Azure​Rm​Sql​Database​Failover​Group

{{Fill in the Synopsis}}

Use-​Azure​Rm​Sql​Server​Auditing​Policy

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