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

title	managed_backup.fn_is_master_switch_on (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-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
dev_langs	TSQL
helpviewer_keywords	smart_admin.fn_is_master_switch_on fn_is_master_switch_on
ms.assetid	e8c2108d-b104-46cb-9645-a15f46112c86
author	MikeRayMSFT
ms.author	mikeray

managed_backup.fn_is_master_switch_on (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]

Returns the state of the [!INCLUDEss_smartbackup] operations on the instance of SQL Server.

Use this function to get the current state of [!INCLUDEss_smartbackup].

Transact-SQL Syntax Conventions

Syntax

managed_backup.fn_is_master_switch_on ()  

Arguments

None

Return Type

BIT

1 = [!INCLUDEss_smartbackup] is active, 0 = [!INCLUDEss_smartbackup] is paused.

Security

Permissions

Requires SELECT permissions on the function.

See Also

SQL Server Managed Backup to Microsoft Azure