Data Restore

With the configured Veeam Plug-In for Microsoft SQL Server, you can restore Microsoft SQL Server databases from Veeam Plug-In backups that reside on Veeam backup repositories.

Veeam Plug-In supports restore of entire databases to the original Microsoft SQL Server machine or to another server. You can specify a point in time to which you want to restore the database. This restore operation is based on backed up transaction logs. If there are no available backed up transaction logs, Veeam Plug-In restores the database to the time when the restore point was created. For details, see Performing Restore.

If you back up Microsoft SQL Server databases with Change Data Capture (CDC) enabled, and you want to preserve CDC configuration and metadata after restore, you must manually add the RestoreWithKeepCdc="true" parameter to the <PluginParameters /> section of the Veeam Plug-In configuration file (veeam_config.xml). For more information on changing Veeam Plug-In configuration, see Configuring Veeam Plug-In for Microsoft SQL Server.

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

Restore with the Restore Database wizard.

Use the Restore Database wizard to restore Microsoft SQL Server databases based on Veeam Plug-In backups. For details, see Restore with Restore Database Wizard.

Restore with MSSQLRecoveryManager.exe tool in the command-line interface.

Use the MSSQLRecoveryManager.exe command-line tool to restore Microsoft SQL Server databases based on Veeam Plug-In backups. For details, see Restore with Command-Line Interface.

Restore with Veeam Explorer for Microsoft SQL Server.

Use Veeam Explorer for Microsoft SQL Server to restore Microsoft SQL Server databases from the Veeam Backup & Replication console. For details, see Restore with Veeam Explorer for Microsoft SQL Server.