Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

managed_backup.fn_is_master_switch_on (Transact-SQL)

Applies to: 👁 Image
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.

👁 Image
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.

See Also

SQL Server Managed Backup to Microsoft Azure


Feedback

Was this page helpful?

Additional resources