Quick Maintenance & Backup for MS SQL
Manual creation of backups

Regular creation of database backups is performed on schedule by maintenance policy QMB Jobs. However, sometimes you need to create a backup manually. To do that, right-click on the necessary database in the list of servers and policies and choose the Create backup command from the context menu. It can also be done using the same-named command on the database page. It will open a new window that will allow you to set the following backup parameters:

Verify after creation – the flag denotes that the program will verify the backup after its creation. The check is performed using the RESTORE VERIFYONLY command, which verifies the completeness of the backup and its readability.

Copying only backup – the flag indicates that the program will create a copy-only backup (with the WITH COPY_ONLY parameter). Such a backup does not interfere with the general sequence of backups and can be deleted later on, for example, after handing it over to another party. The option is available for SQL Server 2005 and newer versions. More information is available in MSDN https://msdn.microsoft.com/en-us/library/ms191495.aspx.

Compress backup - the flag sign indicates that a compressed backup should be made (with COMPRESSION or NO_COMPRESSION parameter). If the SQL server does not support compression, the option will be disabled.

There are some limitations for compressed backup files. For example, a backup file cannot contain compressed and non-compressed sets of backup copies. Also, you should bear in mind that you won’t be able to restore a compressed backup copy on an SQL server that doesn’t support backup compression, such as SQL Express, for example. More details can be found in MSDN.

The backup is saved to the folder specified in the maintenance policy. The file is named according to the following pattern InstanceName_DatabaseName_Full_Data_Time.bak

See Also

General Information