Export (0) Print
Expand All

smart_admin.sp_backup_on_demand

SQL Server 2014

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

Topic link icon Transact-SQL Syntax Conventions

EXEC smart_admin.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 smart_admin.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:
© 2014 Microsoft