About Microsoft SQL Server Backup
Veeam Plug-in uses native Microsoft SQL Server mechanisms to create application-level backups of Microsoft SQL Server data. You can use Veeam Plug-in to create backups of the following types.
- Full backup
- Differential backup
- Log backup
- Copy-only full backup
- Copy-only log backup
For more information about Microsoft SQL Server backup types, see Microsoft Documentation.
To create backups of a specific type, you must configure backup settings for Veeam Plug-in and run the backup process. You can run the backup process manually, immediately after you configure backup settings, or you can define schedule according to which Veeam Plug-in will back up Microsoft SQL Server data automatically. For more information, see Backup Settings and Backup Schedule.
Important |
For read-only databases, Veeam Plug-in for Microsoft SQL Server supports only full and copy-only full backups. Differential, log and copy-only log backups are not supported. |
To specify backup settings, Veeam Plug-in offers the Back Up Database wizard. Alternatively, you can use the MSSQLRecoveryManager.exe command-line tool to specify backup settings and start the backup process. For more information, see Configuring Backup Settings and Performing Backup with Command-Line Interface.
In addition, you can use Microsoft SQL Server Management Studio or a third-party scheduling tool to define schedule for database backup.
If you want to perform backups of different types periodically, you must configure backup settings and specify schedule for each backup type. For example, you can specify settings for full backup, settings for differential backup and settings for log backup, save each of these settings as a separate SQL Agent job, and create schedule for these SQL Agent jobs in Microsoft SQL Server Management Studio.
Veeam Plug-in for Microsoft SQL Server offers two scenarios for backup scheduling:
- Scenario 1. You can configure backup schedule in Microsoft SQL Server. To do this, you must save Veeam Plug-in backup settings as an SQL Agent job. For more information, see Saving Backup Settings as SQL Agent Job.
After that, you will be able to configure job schedule in the properties of the SQL Agent job in Microsoft SQL Server Management Studio.
- Scenario 2. You can use a third-party scheduling tool to create periodic backups of Microsoft SQL Server data with Veeam Plug-in. To do this, you must configure Veeam Plug-in backup settings and obtain a command that will be used to start the backup process. For more information, see Exporting Backup Settings to Custom Script.
After that, you will be able to use the resulting command in a custom backup script or with a scheduling tool of your choice.
Related Topics