Export (0) Print
Expand All

managed_backup.sp_backup_on_demand (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Requests SQL Server Managed Backup to Windows Azure to perform a backup of the specified database.

Use this stored procedure to perform ad hoc backups for a database configured with SQL Server Managed Backup to Windows Azure. This prevents any break in the backup chain and SQL Server Managed Backup to Windows Azure processes are aware and the backup is stored in the same Windows Azure Blob storage container.

Upon successful completion of the backup the full backup file path is returned. This includes the name and location of the new backup file resulting from the backup operation.

An error is returned if SQL Server Managed Backup to Windows Azure is in the process of executing a backup of given type for the specified database. In this case, the error message returned includes the full backup file path where the current backup is being uploaded to.

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_on_demand 
[@database_name  =]  'database name',[@type = ] { 'Database' | 'Log' }

@database_name

The name of the database on which the backup is to be performed. The @database_name is SYSNAME.

@type

The type of backup to be performed: Database or Log. The @type parameter is NVARCHAR(32).

0 (success) or 1 (failure)

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 makes a database backup request for the database ‘TestDB’. This database has SQL Server Managed Backup to Windows Azure enabled.

Use MSDB
Go
EXEC managed_backup.sp_backup_on_demand
 @database_name = 'TestDB'
,@type = 'Database'

For each code snippet, select 'tsql' in the language attribute field.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft