How Restore Works

Restoring databases with Veeam Explorer for Microsoft SQL Server works in the following manner:

1. Veeam Explorer for Microsoft SQL Server connects to the target server and performs a series of validations. For example, it checks if the database exists on the target server and if the target server has enough free space for the restored database.

To perform these validations and required file operations, Veeam Explorer for Microsoft SQL Server deploys the Veeam SQL Restore Service on the target server and, if you restore your data up to a specific transaction, on the staging server. This non-persistent runtime component checks the valid rights assignments required for database recovery, gets information about the databases, and later performs required file operations including database and transaction logs copy. The Veeam SQL Restore Service is removed from the target and the staging server once the restore process is completed. For more information, see How Data Recovery Works.

2. Veeam Explorer for Microsoft SQL Server sends a restore command to the Veeam Mount Service running on the mount server associated with the backup repository. The service connects to the backup repository and prepares the mounting operation.
3. The Veeam Mount Service mounts the necessary file system to the C:\VeeamFLR directory on the target Microsoft SQL Server machine. For more information, see How Mounting Works.
4. The Veeam SQL Restore Service copies the database files and the transaction log backups from the mounted file system to the regular file system of the target machine and starts the restored database.

After the restore operation successfully completes, Veeam Explorer for Microsoft SQL Server unmounts the mounted file system from the target server.