Edit

managed_backup.fn_backup_instance_config (Transact-SQL)

  • Article

Applies to: SQL Server 2016 (13.x) and later versions

Returns 1 row with the SQL Server managed backup to Microsoft Azure default configuration settings for the instance of SQL Server.

Use this stored procedure to review or determine the current SQL Server managed backup to Microsoft Azure default configuration settings for the instance of SQL Server.

Transact-SQL syntax conventions

Syntax

managed_backup.fn_backup_db_config ()

Arguments

None

Table Returned

Column Name Data Type Description
is_smart_backup_enabled INT Displays 1 when SQL Server managed backup to Microsoft Azure is enabled, and 0 when SQL Server managed backup to Microsoft Azure is disabled.
credential_name SYSNAME Default SQL Credential used to authenticate to the storage.
retention_days INT Default retention period set at the instance level.
storage_url NVARCHAR(1024) The default storage account URL set at the instance level.
encryption_algorithm SYSNAME Name of the encryption algorithm. Is set to NULL if encryption is not specified.
encryptor_type NVARCHAR(32) The type of encryptor used: Certificate or Asymmetric Key. Is set to NULL if there is no encryptor specified.
encryptor_name SYSNAME The name of the certificate or asymmetric key. Is set to NULL if there is no name specified

Security

Permissions

Requires membership in the db_backupoperator database role with ALTER ANY CREDENTIAL permissions. The user should not be denied VIEW ANY DEFINITION permissions.

Examples

The following example returns the SQL Server managed backup to Microsoft Azure default configuration settings for the instance it is executed on:

Use msdb;  
GO  
SELECT * FROM managed_backup.fn_backup_instance_config ();