sys.fn_backup_db_config

Description

2016 (13.x) and later versions Returns 0, 1 or more rows with SQL Server managed backup to Microsoft Azure configuration settings. Returns 1 row for the specified database, or returns the information for all the databases configured with SQL Server managed backup to Microsoft Azure on the instance.

Syntax

managed_backup.fn_backup_db_config ('database_name' | '' | NULL)

Examples

Example 1

Use msdb
GO
SELECT * FROM managed_backup.fn_backup_db_config('TestDB')
Use msdb
GO
SELECT * FROM managed_backup.fn_backup_db_config (NULL)