In addition to scheduled backups, you can perform manual on-demand backups of a single database or multiple databases. These manual backups might be deemed necessary prior to system maintenance or system upgrade. The on-demand transaction always performs a full backup. Differential or transaction log backups cannot be specified when utilizing this feature.
Log in to the appropriate SQL Server instance by clicking Login To SQL Server and selecting the desired Backup Server Name (backup system) and the Backup Device Name (disk device) where the backup files are to be saved. Select a single database or multiple databases for backup by clicking on one or more database name(s). If all databases are to be included, use Select All.
Clicking Submit Backup Job submits the requested backup jobs to the backup system, but execution begins upon availability of the system’s resources. The status of the requested backups can be viewed via the View Backup History interface.
Note: SQL agent on-demand and scheduled backups fail in single user mode when launched from the command line but they work successfully when invoked in single user mode from the SQL Server. The SQL agent supports backup of the Master database in single user mode.