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

How It Works: SQL Server Database Restore

Veeam Backup & Replication supports several methods of SQL Server restore from the backup. They are based on Veeam’s patented vPower technology that allows you to run a VM directly from a compressed and deduplicated backup file, eliminating the need to extract the backup and copy it to production storage. Instead, Veeam exposes the VM files in a backup repository through a disk mount. Local disk space is used as a temporary write area while the VM is running from the backup. This approach is used to carry out the whole VM restore with Instant VM Recovery, Full VM Restore, as well as to perform VM disk recovery or file-level restore of the guest OS (see https://helpcenter.veeam.com/backup/vsphere/data_recovery.html for more information on restore options).

Veeam Backup & Replication also offers a convenient tool to extend the set of restore options – Veeam Explorer for Microsoft SQL Server, installed together with Veeam Backup & Replication server or standalone console as a part of Veeam setup. This tool helps you to restore databases from the SQL Server image-level backup to the original or different location, without a need to recover the whole server VM. The basic restore procedure includes the following steps:

How It Works: SQL Server Database Restore 

  1. The backup administrator uses Veeam Backup & Replication restore options to mount database files from the SQL Server's backup, making database hierarchy available for browsing and search.
  2. Veeam Explorer for Microsoft SQL Server obtains SQL Server hierarchy information (instances and databases) and presents it to user, facilitating browsing and search. A user selects and follows the necessary database restore scenario.
    Veeam Explorer for Microsoft SQL Server supports several scenarios that are similar for database restore and export:
  • Restore/export to current restore point (the one currently mounted to Veeam backup server)
  • Restore/export to selected point in time
  • Restore/export to the state before selected transaction.

The first scenario involves target SQL Server only; others involve target and staging SQL Servers, as follows:

 

Restore scenario

Export scenario

 

To point in time

To selected transaction

To point in time

To selected transaction

Staging SQL Server

Not involved

Yes (involved; presents log to user)

Yes (involved)

Yes (involved; presents log to user, supports log replay)

Target SQL Server

Yes (involved; supports log replay)

Yes (involved; supports log replay)

Not involved

Not involved

  1. Finally, the database is ‘re-created’ on the target Microsoft SQL Server and becomes ready for use. If the export scenario was used, exported database can be then attached to the SQL Server you need.

How It Works: SQL Server Database Restore Note:

For more information, refer to https://helpcenter.veeam.com/backup/explorers/vesql_hiw.html.

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