Export (0) Print
Expand All

smart_admin.sp_ backup_master_switch

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 2014 through current version).

Topic link icon Transact-SQL Syntax Conventions

EXEC smart_admin.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.

Permissions

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 smart_admin.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 smart_admin.sp_master_switch @state=1;
Go
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft