Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
managed_backup.sp_ backup_master_switch (Transact-SQL)

managed_backup.sp_ backup_master_switch (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Pauses or resumes the SQL Server Managed Backup to Windows Azure.

Use this stored procedure to temporarily pause and them resume SQL Server Managed Backup to Windows Azure. This makes sure that all the configurations settings remain and is retained when the operations resume. When SQL Server Managed Backup to Windows Azure is paused the retention period is not enforced. This means that there is no check to determine whether files should be deleted from storage or if there are backup file corrupted, or break in log chain.

Applies to: SQL Server (SQL Server 2016 Community Technology Preview 2 (CTP2) through current version).

Topic link icon Transact-SQL Syntax Conventions

EXEC managed_backup.sp_backup_master_switch 
                     [@state = ] { 0 | 1}

@state

Set the state of SQL Server Managed Backup to Windows Azure. The @state parameter is BIT. When set to a value of 0 the operations are paused, and when set to a value of 1 the operation resume.

0 (success) or 1 (failure)

Describes security issues related to the statement.Include Permissions as a subsection (H3 heading). Consider including other subsections for Ownership Chaining and Auditing if appropriate.

Requires membership in db_backupoperator database role, with ALTER ANY CREDENTIAL permissions, and EXECUTE permissions on sp_delete_backuphistory stored procedure.

The following example can be used to pause SQL Server Managed Backup to Windows Azure on the instance it is executed on:

Use msdb;
GO
EXEC managed_backup.sp_master_switch @state=0;
Go

The following example can be used to resume SQL Server Managed Backup to Windows Azure.

Use msdb;
GO
EXEC managed_backup.sp_master_switch @state=1;
Go

Community Additions

ADD
Show:
© 2015 Microsoft