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

Policies SQL

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 SQL Collection 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": [

"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": [

"retention": {

"timeRetentionDuration": 14,

"retentionDurationType": "Days"

"targetRepositoryId": "12"

}

...

"_links": {

"self": {

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

}