List Recoverable Databases (classic)

 

Updated: October 5, 2016

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel 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.

MethodRequest URIHTTP Version
GEThttps://management.core.windows.net/{subscriptionId}/services/sqlservers/servers/{serverName}/recoverabledatabases?contentview=genericHTTP/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:

XML
Copy 
<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 NameDescription
IdSpecifies the identifier for this resource.
NameSpecifies the name of the database.
EditionSpecifies the edition of the database.
MaxSizeGBSpecifies the maximum size of the database.
CreationDateSpecifies the original creation date of the database.
LastAvailableBackupDateSpecifies 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

Show: