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

title	managed_backup.fn_is_master_switch_on (Transact-SQL)
description	managed_backup.fn_is_master_switch_on (Transact-SQL)
author	MikeRayMSFT
ms.author	mikeray
ms.date	06/10/2016
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	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
helpviewer_keywords	smart_admin.fn_is_master_switch_on fn_is_master_switch_on
dev_langs	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