List Recoverable Databases (classic)
Updated: October 5, 2016
SQL Server
Azure SQL Database
Azure SQL Data Warehouse
Parallel Data Warehouse
Gets a list of all recoverable databases on an Azure SQL Database server.
This command uses the classic deployment model. You should use the newer Resource Manager based REST API commands located here. For more information, see Azure Resource Manager vs. classic deployment: Understand deployment models and the state of your resources.
The List Recoverable Databases request must be specified as follows:
Replace {subscriptionId} with your subscription ID.
Replace {serverName} with the server name that contains the recoverable databases you want to list.
| Method | Request URI | HTTP Version |
|---|---|---|
| GET | https://management.core.windows.net/{subscriptionId}/services/sqlservers/servers/{serverName}/recoverabledatabases?contentview=generic | HTTP/1.1 |
URI Parameters
None.
Request Headers
None.
Request Body
None.
The response includes an HTTP status code, and a response body.
Status Code
Response status code 200 indicates the request succeeded.
Response Body
The following is an example response body:
<m:properties> <d:Id m:type="Edm.Int32">{database-id}</d:Id> <d:Name>{database-name}</d:Name> <d:Edition>{database-edition}</d:Edition> <d:LastAvailableBackupDate m:type="Edm.DateTime">{value}</d:LastAvailableBackupDate> </m:properties> <?xml version="1.0" encoding="utf-8" standalone="yes"?> <feed xml:base="https://abcd1234.database.windows.net/v1/ManagementService.svc/Server2('abcd1234')/" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/Atom"> <title type="text">DroppedDatabases</title> <id>https://abcd1234.database.windows.net/v1/ManagementService.svc/ Server2('serverName')/recoverabledatabases</id> <updated>2012-11-09T17:59:43Z</updated> <link rel="self" title="Databases" href="recoverabledatabases" /> <entry> <id>https://abcd1234.database.windows.net/v1/ManagementService.svc/Server2/recoverabledatabases(1)</id> <title type="text"></title> <updated>2012-11-09T22:59:43Z</updated> <author> <name /> </author> <link rel="edit" title="Database" href="recoverabledatabases(1)" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Server" type="application/atom+xml;type=entry" title="Server" href="recoverabledatabases(1)/Server" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/DatabaseMetrics" type="application/atom+xml;type=entry" title="DatabaseMetrics" href="recoverabledatabases(1)/DatabaseMetrics" /> <category term="Microsoft.SqlServer.Management.Server.Domain.RecoverableDatabase" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <content type="application/xml"> <m:properties> <d:Id m:type="Edm.Int32">1</d:Id> <d:Name>foo</d:Name> <d:Edition>Basic</d:Edition> <d:MaxSizeGB m:type="Edm.Int32">5</d:MaxSizeGB> <d:CreationDate m:type="Edm.DateTime">{value}</d:CreationDate> <d:LastAvailableBackupDate m:type="Edm.DateTime">{value}</d:LastAvailableBackupDate> </m:properties> </content> </entry> </feed>
The following table describes the elements of the response body:
| Element Name | Description |
|---|---|
| Id | Specifies the identifier for this resource. |
| Name | Specifies the name of the database. |
| Edition | Specifies the edition of the database. |
| MaxSizeGB | Specifies the maximum size of the database. |
| CreationDate | Specifies the original creation date of the database. |
| LastAvailableBackupDate | Specifies the date of the last backup for the database. |
To check if a specific database is available for recovery, see Get Recoverable Database (classic). To recover a recoverable database, see Create Database Recovery Request (classic).
Recover an Azure SQL database using Geo-Restore with REST API
Common REST API Error Codes
Azure SQL Database
Operations for Azure SQL Databases
Copying Databases in Azure SQL Database
Geo-Replication in Azure SQL Database
Azure SQL Database Cmdlets