TechNet
Export (0) Print
Expand All

managed_backup.fn_is_master_switch_on (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the state of the SQL Server Managed Backup to Microsoft Azure operations on the instance of SQL Server.

Use this function to get the current state of SQL Server Managed Backup to Microsoft Azure.

Topic link icon Transact-SQL Syntax Conventions

managed_backup.fn_is_master_switch_on ()  

None

BIT

1 = SQL Server Managed Backup to Microsoft Azure is active, 0 = SQL Server Managed Backup to Microsoft Azure is paused.

Permissions

Requires SELECT permissions on the function.

SQL Server Managed Backup to Microsoft Azure

Community Additions

ADD
Show:
© 2016 Microsoft