| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
managed_backup.fn_backup_instance_config (Transact-SQL) |
managed_backup.fn_backup_instance_config (Transact-SQL) |
MikeRayMSFT |
mikeray |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sqlserver2016]
Returns 1 row with the [!INCLUDEss-managed-backup] default configuration settings for the instance of SQL Server.
Use this stored procedure to review or determine the current [!INCLUDEss-managed-backup] default configuration settings for the instance of SQL Server.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
managed_backup.fn_backup_db_config () None
| Column Name | Data Type | Description |
|---|---|---|
| is_smart_backup_enabled | INT | Displays 1 when [!INCLUDEss-managed-backup] is enabled, and 0 when [!INCLUDEss-managed-backup] 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 |
Requires membership in the db_backupoperator database role with ALTER ANY CREDENTIAL permissions. The user should not be denied VIEW ANY DEFINITION permissions.
The following example returns the [!INCLUDEss-managed-backup] default configuration settings for the instance it is executed on:
Use msdb;
GO
SELECT * FROM managed_backup.fn_backup_instance_config ();