Data Backup

Veeam Plug-in for Microsoft SQL Server integrates and uses native Microsoft SQL Server mechanisms to back up data to the Veeam backup repository.

With the configured Veeam Plug-in, you can back up Microsoft SQL Server databases, as well as configure backup schedules for full, differential and log backups using built-in tools of Microsoft SQL Server. You can also perform independent copy-only full backups and copy-only log backups to not affect the database backup chain. For details on backup operations, see About Microsoft SQL Server Backup.

You can use the following tools to perform backup operations for Microsoft SQL Server databases:

  • Back up with the Back Up Database wizard.

When you use the Back Up Database wizard, you can specify the backup settings for Veeam Plug-in backups of Microsoft SQL Server databases. You can also use Microsoft SQL Server Management Studio or a third-party scheduling tool to define the schedule for database backup. For details, see Configuring Backup Settings.

  • Back up with the MSSQLRecoveryManager.exe tool in the command-line interface.

When you use the MSSQLRecoveryManager.exe tool, you can specify backup parameters to configure, perform and schedule all types of backups in the command-line interface. You can also use the backup parameters to modify Veeam Plug-in for Microsoft SQL Server commands used in custom scripts. For details, see Performing Backup with Command-Line Interface.

After Veeam Plug-in for Microsoft SQL Server starts the backup process, Veeam Backup & Replication creates the backup job. You can use this job to monitor backup processes and generate backup job reports. You cannot start or edit Microsoft SQL Server backup jobs in the Veeam Backup & Replication console. You can manage backup operations on the Microsoft SQL Server machine only. For details, see Managing Backup Job in Veeam Backup & Replication.

To store backups, you can add and configure backup repositories to your Veeam Backup & Replication infrastructure. For details on supported backup repositories, see Veeam Backup Repositories.


Page updated 4/23/2024

Page content applies to build