Policies SQL

In this article

    The /policies/sql resource collection represents all Azure SQL backup policies created in Veeam Backup for Microsoft Azure.

    Collection URL

    The resource collection is located at the following URL:

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

    Policies SQLCollection Representation

    {

     "offset": 0,

     "limit": 200,

     "totalCount": 13,

     "results": [

       {

         "id": "8cd8d89f-e774-4a3d-a87a-f77f5d2d432b",

         "priority": 1,

         "excludedItemsCount": 0,

         "tenantId": "97768793-c924-4a51-8875-d33056db7b9b",

         "serviceAccountId": "0245c241-165d-75ce-a84e-aff90c48d40d",

         "usn": 24327,

         "backupStatus": "Warning",

         "nextExecutionTime": "2021-09-06T20:00:00Z",

         "_links": {

           "self": {

             "href": "https://51.11.247.127/api/v3/policies/sql/8cd8d89f-e774-4a3d-a87a-f77f5d2d432b"

           }

         },

         "name": "AzureSQL_policy",

         "description": "",

         "retrySettings": {

           "retryCount": 3

         },

         "policyNotificationSettings": {

           "recipient": "peter.jensen@gmail.com",

           "notifyOnSuccess": false,

           "notifyOnWarning": false,

           "notifyOnFailure": false

         },

         "isEnabled": true,

         "backupType": "SelectedItems",

         "dailySchedule": {

           "dailyType": "SelectedDays",

           "selectedDays": [

             "Monday"

           ],

           "backupSchedule": {

             "hours": [

               22

             ],

             "retention": {

               "timeRetentionDuration": 14,

               "retentionDurationType": "Days"

             },

             "targetRepositoryId": "2"

           }

         }

       },

       {

         "id": "8c7fa0fa-825f-4102-9d65-d9a6e355de19",

         "priority": 2,

         "excludedItemsCount": 0,

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

         "serviceAccountId": "0455c811-112d-43ce-a84e-aff90c48d40d",

         "usn": 23431,

         "backupStatus": "Success",

         "nextExecutionTime": "2021-09-07T20:00:00Z",

         "_links": {

           "self": {

             "href": "https://51.11.247.127/api/v3/policies/sql/8c7fa0fa-825f-4102-9d65-d9a6e355de19"

           }

         },

         "name": "AzureSQL_001",

         "description": "",

         "retrySettings": {

           "retryCount": 3

         },

         "policyNotificationSettings": {

           "recipient": "peter.jensen@gmail.com",

           "notifyOnSuccess": false,

           "notifyOnWarning": false,

           "notifyOnFailure": false

         },

         "isEnabled": true,

         "backupType": "SelectedItems",

         "dailySchedule": {

           "dailyType": "SelectedDays",

           "selectedDays": [

             "Tuesday"

           ],

           "backupSchedule": {

             "hours": [

               22

             ],

             "retention": {

               "timeRetentionDuration": 14,

               "retentionDurationType": "Days"

             },

             "targetRepositoryId": "12"

           }

         }

       },

    ...

     ],

     "_links": {

       "self": {

         "href": "https://51.11.247.127/api/v3/policies/sql?offset=0&limit=200"

       }

     }

    }