Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) and later versions
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.
Transact-SQL syntax conventions
Syntax
managed_backup.fn_is_master_switch_on ()
Arguments
None
Return Type
BIT
1 = SQL Server managed backup to Microsoft Azure is active, 0 = SQL Server managed backup to Microsoft Azure is paused.
Security
Permissions
Requires SELECT permissions on the function.