Help Center
Choose product document...
Veeam Backup & Replication 9.0
Backup and Restore of SQL Server Databases

Restoring Database Schema and Data

Veeam Explorer allows you to restore certain database schema objects and data, using similar scenarios (restore to the current state, to specific point in time, or to the state before selected transaction).

Do the following:

  1. Click Restore Schema > Restore database schema and data on the toolbar, or use the database's shortcut menu command.
  2. Then go through the steps of the restore wizard, specifying the necessary options for the scenario you need.
  3. At the Select database objects step, review the list of database objects. Use the Object and Data check boxes to specify whether a database object and\or data should be restored.

Restoring Database Schema and Data 

To display only specific objects, click Filters and select the object type:

Restoring Database Schema and Data 

  1. Specify object names for the objects after restore. When proceeding to this step, Veeam Explorer checks for object name in backup to exist in the target database:
  • If no duplicates exist, new name will be the same as the original name.
  • If any duplicates are found, you will get a message asking to provide different new name. You can click Auto to create new names automatically - then Veeam Explorer will use the original names followed by suffix (for example, <name>_newsuffix). You can edit the name if necessary and click Auto to check for duplicates again. If the check is a success, you can proceed to the next step.

Restoring Database Schema and Data 

  1. On the next step, specify additional restore options.

Select how the filegroups should be restored for selected schema object(s):

  • Preserve filegroup - with this option selected, original filegroup will be restored. If this scenario is not applicable (for example, no such filegroup exists on target), then default filegroup configured on target will be used.
  • Use the following filegroup - select the necessary filegroup on target.

Select how partitioned tables should be restored:

  • Preserve partition schema - with this options selected, the table will be restored to the original partition schema (if applicable; if not - default partition schema on target will be used)
  • Use the following partition schema - select the necessary partition schema on target.
  • Use the following filegroup - alternatively, select the filegroup on target to be used at restore.

Restoring Database Schema and Data 

Then click Restore and wait for the restore process to complete.

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Administrator Guide

Veeam Backup Explorers User Guide

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam Direct Restore to Microsoft Azure

Veeam Backup FREE Edition User Guide

Veeam ONE Documentation

Veeam Endpoint Backup Documentation

Veeam Management Pack Documentation