Share via


Get a SQL Server Database

 

Applies To: Windows Azure Pack

Retrieves a SQL Server database by name.

Request

Replace <TenantAPI> with your Service Management API endpoint address, <SubscriptionId> with the tenant subscription identifier, and <DatabaseName> with the name of the database to retrieve.

Method

Request URI

HTTP version

GET

https://<TenantAPI>:30005/<SubscriptionId>/services/sqlservers/databases/<DatabaseName>

HTTP/1.1

URI Parameters

None.

Request Headers

The following table describes required and optional request headers.

Request header

Description

Authorization: Bearer

Required. The authorization bearer token.

x-ms-principal-id

Required. The principal identifier.

x-ms-client-request-id

Optional. The client request identifier.

x-ms-client-session-id

Optional. The client session identifier.

x-ms-principal-liveid

Optional. The principal Live identifier.

Request Body

None.

Response

The response includes an HTTP status code, a set of response headers, and a response body.

Status Code

A successful operation returns status code 200 (OK).

Response Headers

The response for this operation includes standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.

Response Body

The following table describes the key elements of the response body:

Element name

Description

SqlDatabase

The new plan. For more information, see SqlDatabase (Object).

See Also

SQL Server Resource Provider Database Interfaces