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

PolicySqlBackupItemV3

The following properties represent the PolicySqlBackupItemV3 JSON schema.

PolicySqlBackupItemV3

Property	Type	Description
database	DatabaseV3	Azure ID assigned to an Azure SQL database protected by a backup policy.
sqlServer	SqlServerV3	Azure ID assigned to an SQL server protected by a backup policy.
deletedItem	PolicySqlItemDeletedFromAzureV3	Information on items that are no longer present in the backup infrastructure.

Property	Type	Description
id	string	System ID assigned to the Azure SQL database in Veeam Backup for Microsoft Azure.
resourceId	string	Azure ID assigned to the Azure SQL database.
name	string	Name of the Azure SQL database.
serverName	string	Name of a server hosting database.
serverId	string	Azure ID assigned to the server hosting the database.
resourceGroupName	string	Information on a resource group where the backup item belongs.
sizeInMb	integer	Size of the database.
subscriptionId	string	Information on an Azure subscription to which the backup item belongs.
regionId	string	Name of the Azure region where the database resides.
hasElasticPool	boolean	Defines whether the database belongs to an elastic pool.
status	array[string]	Status of the database: Other, Online, Restoring, RecoveryPending, Recovering, Suspect, Offline, Standby, Shutdown, EmergencyMode, AutoClosed, Copying, Creating, Inaccessible, OfflineSecondary, Pausing, Paused, Resuming, Scaling, OfflineChangingDwPerformanceTiers, OnlineChangingDwPerformanceTiers, Disabled.
databaseType	array[string]	Type of the database: Managed, Unmanaged.
_links	string	A list of methods and operations available for the backup policy in the Veeam Backup for Microsoft Azure REST API, and request URLs used to perform the operations.

Property	Type	Description
id	string	System ID assigned to the SQL server in Veeam Backup for Microsoft Azure.
name	string	Name of the SQL server.
resourceId	string	Azure ID assigned to the SQL server.
subscriptionId	string	Information on an Azure subscription to which the SQL server belongs.
regionId	string	Name of the Azure region where the SQL server resides.
serverType	array[string]	Type of the SQL server: Managed, Unmanaged.
_links	string	A list of methods and operations available for the backup policy in the Veeam Backup for Microsoft Azure REST API, and request URLs used to perform the operations.

PolicySqlItemDeletedFromAzureV3

Property	Type	Description
type	array[string]	Type of the item removed from backup infrastructure: Database, SqlServer.
name	string	Name of the policy item.
id	string	System ID assigned to the policy item in Veeam Backup for Microsoft Azure.