managed_backup.fn_backup_instance_config (Transact-SQL)
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 ();