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 Docs.
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.
Veeam Plug-in backs up Microsoft SQL Server databases according to backup settings that you specify. You can specify what databases to back up, what type of backups you want to create, retention policy for database backups and processing settings for backed-up data.
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 does not offer its own backup schedule mechanisms. Instead, Veeam Plug-in allows database administrators to use tools of their choice to configure flexible schedule for database backup. For example, you can use native Microsoft SQL Server schedule settings to configure flexible schedule for full, differential or log backups, or use an external scheduling tool.
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.