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

Database Collection 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"

}