Get a SQL Server Database
Applies To: Windows Azure Pack
Retrieves a SQL Server database by name.
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 |
None.
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. |
None.
The response includes an HTTP status code, a set of response headers, and a response body.
A successful operation returns status code 200 (OK).
The response for this operation includes standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.
The following table describes the key elements of the response body:
Element name | Description |
|---|---|
SqlDatabase | The new plan. For more information, see SqlDatabase (Object). |