This is an archive version of the document. To get the most up-to-date information, see the current version.

Protected Azure SQL Databases

The /protectedItem/sql resource collection represents all Azure SQL databases protected by Veeam Backup for Microsoft Azure.

Collection URL

The resource collection is located at the following URL:

https://<hostname>/api/v3/protectedItem/sql

Protected Azure SQL Databases Collection Representation

{

"offset": 0,

"limit": 2,

"totalCount": 7,

"results": [

{

"id": "c7f7o8ndjoq36w7azqjotsbn71z9y9s7macyni7jhziehit88b5y",

"azureId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/dept_003/providers/microsoft.sql/managedinstances/dept_003-managedinstance/databases/sea-northwind",

"name": "sea-northwind",

"sqlServer": {

"id": "pq1h9kjb66ez3yd5qjjdtqd3td9tpsmgcwtt8ibttqjkdstxzq1y",

"name": "dept_003-managedinstance",

"serverType": "Managed"

"azureEnvironment": "Global",

"sizeInMb": 2,

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

"lastBackup": "2021-09-03T18:40:09Z",

"subscription": {

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

"environment": "Global",

"tenantId": "97438793-c913-4a51-8485-d33056db7b9b",

"tenantName": "Veeam Software Group GmbH",

"name": "Enterprise - QA",

"status": "Active"

"region": {

"id": "southeastasia",

"name": "southeastasia"

"resourceGroup": {

"id": "a3pwec91eqphct9o1ihdiotbekyxcabcjqo56bkmr7bybrzid33o",

"resourceId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/jf_sea",

"name": "jf_sea",

"azureEnvironment": "Global",

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

"regionId": "southeastasia"

"_links": {

"restorepoint": {

"href": "https://51.11.247.127/api/v3/restorePoints/sql/1c5bf43a-bc18-4c92-8c65-87602b565aae"

"subscription": {

"href": "https://51.11.247.127/api/v3/cloudInfrastructure/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f"

"resourcegroup": {

"href": "https://51.11.247.127/api/v3/cloudInfrastructure/resourceGroups/a3pwec91eqphct9o1ihdiotbekyxcabcjqo56bkmr7bybrzid33o"

}

{

"id": "efs1brhjhbjxdgxrd5111a6155b1pq7i5chk6qg6nmhrgx9qs7wy",

"azureId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/jf_uk/providers/microsoft.sql/managedinstances/uk-sql-managedinstance/databases/db-sql",

"name": "db-sql",

"sqlServer": {

"id": "yt9o7xc9b5ien885b89px1pnknia6qa7jyeuba8kdf3y7y4r5nzo",

"name": "uk-sql-managedinstance",

"serverType": "Managed"

"azureEnvironment": "Global",

"sizeInMb": 3,

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

"lastBackup": "2021-08-20T11:26:00.71406Z",

"subscription": {

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

"environment": "Global",

"tenantId": "97438793-c913-4a51-8485-d33056db7b9b",

"tenantName": "Veeam Software Group GmbH",

"name": "Enterprise - QA",

"status": "Active"

"region": {

"id": "uksouth",

"name": "uksouth"

"resourceGroup": {

"id": "6k9q3biyjy5nm174uzkng5skd56e91agxi81gwru4hfecdd6a9my",

"resourceId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/jf_uk",

"name": "dept_005_uk",

"azureEnvironment": "Global",

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

"regionId": "uksouth"

"_links": {

"restorepoint": {

"href": "https://51.11.247.127/api/v3/restorePoints/sql/474d35c4-d89e-44f4-b526-3815aa697a7b"

"subscription": {

"href": "https://51.11.247.127/api/v3/cloudInfrastructure/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f"

"resourcegroup": {

"href": "https://51.11.247.127/api/v3/cloudInfrastructure/resourceGroups/6k9q3biyjy5nm174uzkng5skd56e91agxi81gwru4hfecdd6a9my"

}

"_links": {

"self": {

"href": "https://51.132.223.33:443/api/v3/protectedItem/sql?offset=0&limit=2"

"next": {

"href": "https://51.132.223.33:443/api/v3/protectedItem/sql?offset=2&limit=2"

}