Protected Azure SQL Databases

In this article

    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 DatabasesCollection 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"

       }

     }

    }