SQL Policy Cost Estimation

The policies/sql/estimateCost resource collection allows you to calculate the estimated monthly cost of using Microsoft Azure resources to protect Azure SQL databases. The estimated cost is available if you specified the backup schedule in backup policy settings.

Calculate Estimated Cost of SQL Backup Policy

The HTTP POST request to the /policies/sql/estimateCost endpoint calculates the estimated monthly cost for protecting resources by a backup policy per SQL database.

SecurityBearer
Request
query Parameters
ResourceNameFilter
string or null

Returns only costs for protecting a SQL database with the specified name.

x-veeam-parameter-group: CostEstimationSqlOptions
Offset
integer <int32> >= 0

Specifies the first N items of a resource collection that will be excluded from the response.

x-veeam-parameter-group: Veeam.Azure.REST.RequestQuery.V2.PageProperties
Limit
integer <int32> >= -1

Specifies the maximum number of items of a resource collection that will be returned in the response.

x-veeam-parameter-group: Veeam.Azure.REST.RequestQuery.V2.PageProperties
Request Body schema: application/json
required
priority
integer <int64>

Specifies the priority ordinal number of the backup policy.

tenantId
string or null

Specifies the Microsoft Azure ID assigned to a tenant for which the backup policy is created.

serviceAccountId
string <uuid>

Specifies the system ID assigned in the Veeam Backup for Microsoft Azure REST API to a service account whose permissions are used to perform backup of Azure SQL databases.

Array of objects or null (PolicyRegionFromClient)

Specifies Azure regions where the protected resources reside.

object or null (SqlPolicyBackupItemsFromClient)

[Applies if the SelectedItems value is specified for the backupType parameter] Specifies information on Azure resources to protect by the backup policy.

object or null (SqlPolicyExcludedItemsFromClient)

Specifies Azure resources to exclude from the backup scope.

stagingServerId
string or null

Specifies the Microsoft Azure ID assigned to a staging server configured for the unmanaged instances.

managedStagingServerId
string or null

Specifies the Microsoft Azure ID assigned to a staging server configured for the managed instances.

name
string or null

Specifies a name of the backup policy.

description
string or null

Specifies a description of the backup policy.

object or null (RetrySettings)

Specifies the retry settings for the backup policy.

object or null (PolicyNotificationSettings)

Specifies the notification settings for the backup policy.

isEnabled
boolean or null

Defines whether the policy is enabled.

backupType
string or null (BackupTypeNullable)

Defines whether you want to include to the backup scope all resources residing in the specified Azure regions and to which the specified service account has access.

Enum: "AllSubscriptions" "SelectedItems" "Unknown"
x-external-type: Veeam.Azure.REST.Latest.BackupType
object or null (DailySqlSchedule)

Specifies daily schedule settings for the backup policy.

object or null (WeeklySqlSchedule)

Specifies weekly schedule settings for the backup policy.

object or null (MonthlySqlSchedule)

Specifies monthly schedule settings for the backup policy.

object or null (YearlySchedule)

Specifies the yearly schedule settings for the backup policy.

object or null (HealthCheckSchedule)

[Applies if backup creation is enabled for the backup policy] Specifies the health check schedule settings.

Responses
200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

415

Client Error

post/api/v8/policies/sql/estimateCost
Request samples
application/json
{
  • "priority": 0,
  • "tenantId": "string",
  • "serviceAccountId": "a814cf67-aaac-43ae-acb4-8d34e82a4b4c",
  • "regions": [
    ],
  • "selectedItems": {
    },
  • "excludedItems": {
    },
  • "stagingServerId": "string",
  • "managedStagingServerId": "string",
  • "name": "string",
  • "description": "string",
  • "retrySettings": {
    },
  • "policyNotificationSettings": {
    },
  • "isEnabled": true,
  • "backupType": "AllSubscriptions",
  • "dailySchedule": {
    },
  • "weeklySchedule": {
    },
  • "monthlySchedule": {
    },
  • "yearlySchedule": {
    },
  • "healthCheckSchedule": {
    }
}
Response samples
application/json
{
  • "offset": 0,
  • "limit": 0,
  • "totalCount": 0,
  • "_links": {},
  • "results": [
    ],
  • "metadata": {
    }
}

Export Estimation Cost Report

The HTTP POST request to the /policies/sql/estimateCost/export endpoint exports the policy cost estimation report to a .CSV or an .XML file.

x-veeam-custom-response: true
SecurityBearer
Request
header Parameters
Accept
string or null

Specifies a media type of representation of the exported data. The default value is text/csv media type.

Request Body schema: application/json
required
priority
integer <int64>

Specifies the priority ordinal number of the backup policy.

tenantId
string or null

Specifies the Microsoft Azure ID assigned to a tenant for which the backup policy is created.

serviceAccountId
string <uuid>

Specifies the system ID assigned in the Veeam Backup for Microsoft Azure REST API to a service account whose permissions are used to perform backup of Azure SQL databases.

Array of objects or null (PolicyRegionFromClient)

Specifies Azure regions where the protected resources reside.

object or null (SqlPolicyBackupItemsFromClient)

[Applies if the SelectedItems value is specified for the backupType parameter] Specifies information on Azure resources to protect by the backup policy.

object or null (SqlPolicyExcludedItemsFromClient)

Specifies Azure resources to exclude from the backup scope.

stagingServerId
string or null

Specifies the Microsoft Azure ID assigned to a staging server configured for the unmanaged instances.

managedStagingServerId
string or null

Specifies the Microsoft Azure ID assigned to a staging server configured for the managed instances.

name
string or null

Specifies a name of the backup policy.

description
string or null

Specifies a description of the backup policy.

object or null (RetrySettings)

Specifies the retry settings for the backup policy.

object or null (PolicyNotificationSettings)

Specifies the notification settings for the backup policy.

isEnabled
boolean or null

Defines whether the policy is enabled.

backupType
string or null (BackupTypeNullable)

Defines whether you want to include to the backup scope all resources residing in the specified Azure regions and to which the specified service account has access.

Enum: "AllSubscriptions" "SelectedItems" "Unknown"
x-external-type: Veeam.Azure.REST.Latest.BackupType
object or null (DailySqlSchedule)

Specifies daily schedule settings for the backup policy.

object or null (WeeklySqlSchedule)

Specifies weekly schedule settings for the backup policy.

object or null (MonthlySqlSchedule)

Specifies monthly schedule settings for the backup policy.

object or null (YearlySchedule)

Specifies the yearly schedule settings for the backup policy.

object or null (HealthCheckSchedule)

[Applies if backup creation is enabled for the backup policy] Specifies the health check schedule settings.

Responses
200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

415

Client Error

post/api/v8/policies/sql/estimateCost/export
Request samples
application/json
{
  • "priority": 0,
  • "tenantId": "string",
  • "serviceAccountId": "a814cf67-aaac-43ae-acb4-8d34e82a4b4c",
  • "regions": [
    ],
  • "selectedItems": {
    },
  • "excludedItems": {
    },
  • "stagingServerId": "string",
  • "managedStagingServerId": "string",
  • "name": "string",
  • "description": "string",
  • "retrySettings": {
    },
  • "policyNotificationSettings": {
    },
  • "isEnabled": true,
  • "backupType": "AllSubscriptions",
  • "dailySchedule": {
    },
  • "weeklySchedule": {
    },
  • "monthlySchedule": {
    },
  • "yearlySchedule": {
    },
  • "healthCheckSchedule": {
    }
}
Response samples
application/problem+json
{
  • "extensions": { },
  • "status": 0,
  • "title": "string",
  • "detail": "string",
  • "type": "string"
}