Transparent Data Encryptions - Get

Gets a database's transparent data encryption configuration.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/transparentDataEncryption/{transparentDataEncryptionName}?api-version=2014-04-01

URI Parameters

Name In Required Type Description
subscriptionId
path True
  • string

The subscription ID that identifies an Azure subscription.

resourceGroupName
path True
  • string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName
path True
  • string

The name of the server.

databaseName
path True
  • string

The name of the database for which the transparent data encryption applies.

transparentDataEncryptionName
path True

The name of the transparent data encryption configuration.

api-version
query True
  • string

The API version to use for the request.

Responses

Name Type Description
200 OK

OK

Examples

Get a database's transparent data encryption configuration

Sample Request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-9187/transparentDataEncryption/current?api-version=2014-04-01

Sample Response

{
  "name": "current",
  "location": "North Europe",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-9187/transparentDataEncryption/current",
  "type": "Microsoft.Sql/servers/databases/transparentDataEncryption",
  "properties": {
    "status": "Enabled"
  }
}

Definitions

TransparentDataEncryption
TransparentDataEncryptionName

The name of the transparent data encryption configuration.

TransparentDataEncryptionStatus

The status of the database transparent data encryption.

Name Type Description
location
  • string

Resource location.

status

The status of the database transparent data encryption.

The name of the transparent data encryption configuration.

Name Description
current

The status of the database transparent data encryption.

Name Description
Disabled
Enabled