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).
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.