Database

In this article

    The /databases resource collection represents all Azure SQL databases that reside in Azure regions selected in backup policy settings and can be protected by Veeam Backup for Microsoft Azure.

    Collection URL

    The resource collection is located at the following URL:

    https://<hostname>/api/v3/databases

    DatabaseCollection Representation

    {

     "offset": 0,

     "limit": 200,

     "totalCount": 73,

     "results": [

       {

         "id": "bsp1m6hd8d9a7zscoe4huh9xrtstqoj39abzywcguyu7yxum8h7y",

         "resourceId": "/subscriptions/123921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/bp-sql/providers/microsoft.sql/servers/bp-server-eus/databases/bp-sql-1",

         "name": "bp-sql-1",

         "serverName": "bp-server-eus",

         "serverId": "qhhre6nua6xdz815cwfquniemcx6zhxpd5addqndfzfpt9fztgjo",

         "resourceGroupName": "bp-sql",

         "sizeInMb": 2048,

         "subscriptionId": "123921a2-220d-45c9-92dd-82b6d5a3a78f",

         "regionId": "eastus",

         "hasElasticPool": false,

         "status": "Online",

         "databaseType": "Unmanaged",

         "_embeddedResources": {},

         "_links": {

           "self": {

             "href": "https://51.11.247.127/api/v3/databases/bsp1m6hd8d9a7zscoe4huh9xrtstqoj39abzywcguyu7yxum8h7y"

           }

         }

       },

       {

         "id": "931396wosfeh5xpbo3rzt5mjybirtye7sm1kafeyrmq4k9aotjpo",

         "resourceId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/bp-sql/providers/microsoft.sql/servers/bp-server-we/databases/bp-sql-1 -restored",

         "name": "bp-sql-1 -restored",

         "serverName": "bp-server-we",

         "serverId": "zbuxm9yzfasp1stzfq84euohfxcnait96x1r8bz13kc9cg4di3po",

         "resourceGroupName": "bp-sql",

         "sizeInMb": 2048,

         "subscriptionId": "280921a2-220d-45c9-92dd-82b6d5a3a78f",

         "regionId": "westeurope",

         "hasElasticPool": false,

         "status": "Online",

         "databaseType": "Unmanaged",

         "_embeddedResources": {},

         "_links": {

           "self": {

             "href": "https://51.11.247.127/api/v3/databases/931396wosfeh5xpbo3rzt5mjybirtye7sm1kafeyrmq4k9aotjpo"

           }

         }

       }

    ...

     ],

     "_links": {

       "self": {

         "href": "https://51.11.247.127/api/v3/databases?offset=0&limit=200&dbFromProtectedRegions=False"

       }

     }

    }