If you use encryption in the backup plan, mind that for security reasons the encryption password is not saved anywhere. If you want to keep the backup plan configuration in the backup storage, select the Save backup plan configuration to the backup storage check box. On the side panel, click + or +Add New Plan, then select the MS SQL item.Ħ.Find the required computer, then click the Configure icon in the Backup Plan Status colimn.On Computers select Remote Management if you use legacy main menu, or open Backup > Computers page in the new main menu.To create a new MS SQL Server backup plan, proceed as follows: This chapter covers the following topics: License: MS SQL Server, MS SQL Server + MS Exchange, Ultimate (Check out Backup Agent Editions)

Note: Only local MS SQL Server instances can be configured for backup. Transaction log backup is allowed for Full and Bulk-Logged recovery models only.

SQL Server performs backup and restore operations following a recovery model defined for the database, specifying how transactions are logged, whether or not this log requires (and allows) backups, as well as what kinds of restore operations are available.

Restore databases directly to MS SQL Server.

Flexible schedules, pre-defined schedule templates.

Copy-only backup (available on the Backup Agent only for now).

Compression (native SQL Server compression if supported, otherwise, a custom compression).

Flexible selection of databases for backup.In case you need to back up the SQL Server data to several locations, select the hybrid backup on the Select Backup Storage step. It is recommended to create only one backup plan for every MS SQL Server database to avoid one plan interfering with another. Managed Backup Service allows you to perform MS SQL Server native backups (full, differential, transaction log) and restores with the benefits of encryption.

Backup sql master