managed-backup-fn-backup-instance-config-transact-sql.md

title	managed_backup.fn_backup_instance_config (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	fn_backup_instance_config smart_admin.fn_backup_instance_config_TSQL fn_backup_instance_config_TSQL smart_admin.fn_backup_instance_config
dev_langs	TSQL
helpviewer_keywords	smart_admin.fn_backup_instance_config fn_backup_instance_config
ms.assetid	2382a547-c0c9-4e1d-87c9-d8526192eb5a
caps.latest.revision	16
author	MikeRayMSFT
ms.author	mikeray
manager	jhubbard

managed_backup.fn_backup_instance_config (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx_md]

Returns 1 row with the [!INCLUDEss_smartbackup] default configuration settings for the instance of SQL Server.

Use this stored procedure to review or determine the current [!INCLUDEss_smartbackup] 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 [!INCLUDEss_smartbackup] is enabled, and 0 when [!INCLUDEss_smartbackup] 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 [!INCLUDEss_smartbackup] default configuration settings for the instance it is executed on:

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