Veeam Backup & Replication 9.5 Update 4
User Guide for VMware vSphere
Related documents

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 ESXi 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 ESXi 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 ESXi host for snapshot mounting
  5. Specify a restore reason
  6. Open the database in Veeam Explorer for Microsoft SQL
This Document Help Center
User Guide for VMware vSphereUser Guide for Microsoft Hyper-VEnterprise Manager User GuideVeeam Cloud Connect GuideVeeam Agent Management GuideVeeam Explorers User GuideBackup and Restore of SQL Server DatabasesVeeam Plug-ins for Enterprise ApplicationsPowerShell ReferenceVeeam Explorers PowerShell ReferenceRESTful API ReferenceRequired Permissions ReferenceQuick Start Guide for VMware vSphereQuick Start Guide for Microsoft Hyper-VVeeam Backup for AWS DocumentationVeeam Availability for Nutanix AHV DocumentationVeeam Backup for Microsoft Office 365 DocumentationVeeam ONE DocumentationVeeam Agent for Windows DocumentationVeeam Agent for Linux DocumentationVeeam Management Pack Documentation
I want to report a typo

There is a misspelling right here:

 

I want to let the Veeam Documentation Team know about that.