Help Center
Choose product document...
Veeam Backup & Replication 9.5
User Guide for VMware vSphere

Using the Microsoft SQL Server Database Restore Wizard

When you run the Microsoft SQL Server Database Restore wizard, Veeam Backup & Replication automatically extracts a Microsoft SQL Server database from the storage snapshot and opens it in Veeam Explorer for Microsoft SQL Server.

As part of this procedure, Veeam Backup & Replication performs the following actions:

  1. Veeam Backup & Replication creates a clone/virtual copy of the storage snapshot and mounts the clone/virtual copy to an ESX(i) host.
  2. Veeam Backup & Replication accesses the configuration file of the virtualized Microsoft SQL Server (VMX) on the snapshot clone/virtual copy and uses this configuration file to register a temporary VM on the ESX(i) host.
  3. Veeam Backup & Replication mounts disks of the Microsoft SQL Server to the temporary VM.
  4. Veeam Backup & Replication locates a Microsoft SQL Server database and attaches the content database to a staging Microsoft SQL Server. As a staging server, Veeam Backup & Replication uses the Microsoft SQL Server on which the Veeam Backup & Replication configuration database is deployed.
  5. Veeam Backup & Replication opens the database in Veeam Explorer for Microsoft SQL Server.

Before you restore Microsoft SQL Server databases from the storage snapshot, check prerequisites. Then use the Microsoft SQL Server Database Restore wizard to restore Microsoft SQL Server databases.

  1. Launch the Microsoft SQL Server Database Restore wizard
  2. Select a VM
  3. Select a restore point
  4. Select an ESX(i) host for snapshot mounting
  5. Specify a restore reason
  6. Open the database in Veeam Explorer for Microsoft SQL
Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Backup Explorers User Guide

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Endpoint Backup Documentation

Veeam Management Pack Documentation