Using the Microsoft SQL Server Database Restore Wizard

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

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 the 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 restored Microsoft SQL server to the temporary VM.
4. Veeam Backup & Replication locates the Microsoft SQL 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 database is deployed.
5. Veeam Backup & Replication opens the restored database in Veeam Explorer for Microsoft SQL.

Before you restore Microsoft SQL databases from the storage snapshot, check prerequisites. Then use the Microsoft SQL Server Database Restore wizard to restore Microsoft SQL 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