managed-backup-fn-is-master-switch-on-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
managed_backup.fn_is_master_switch_on (Transact-SQL)	managed_backup.fn_is_master_switch_on (Transact-SQL)	MikeRayMSFT	mikeray	06/10/2016	sql	system-objects	reference	fn_is_master_switch_on fn_is_master_switch_on_TSQL smart_admin.fn_is_master_switch_on smart_admin.fn_is_master_switch_on_TSQL	smart_admin.fn_is_master_switch_on fn_is_master_switch_on	TSQL

managed_backup.fn_is_master_switch_on (Transact-SQL)

[!INCLUDE sqlserver2016]

Returns the state of the [!INCLUDEss-managed-backup] operations on the instance of SQL Server.

Use this function to get the current state of [!INCLUDEss-managed-backup].

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

managed_backup.fn_is_master_switch_on ()  

Arguments

None

Return Type

BIT

1 = [!INCLUDEss-managed-backup] is active, 0 = [!INCLUDEss-managed-backup] is paused.

Security

Permissions

Requires SELECT permissions on the function.

See Also

SQL Server Managed Backup to Microsoft Azure