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 persistent or runtime components on the target server and, if you restore your data up to a specific transaction, on the staging server. These components check the valid rights assignments required for database recovery, get information about the databases, and later perform required file operations including database and transaction logs copy. For more information, see Deploying Persistent and Non-Persistent Components.

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 persistent or runtime components copy the database files and the transaction log backups from the mounted file system to the native file system of the target machine and start the restored database.

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