How Export Works

Veeam Explorer for Microsoft SQL Server allows you to export databases to the machine where Veeam Explorer for Microsoft SQL Server is opened. You can export your database as database files (MDF and LDF files) or as a BAK file.

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

1. Veeam Explorer for Microsoft SQL Server connects to the Veeam Mount Service and the staging server and performs a series of validations. For example, it checks if the staging server has enough free space for the staged data.

Veeam Explorer for Microsoft SQL Server deploys the Veeam SQL Restore Service on the staging server. This non-persistent runtime component checks the valid rights assignments required for export, gets information about the databases, and later performs required file operations. The Veeam SQL Restore Service is removed from the staging server once the export process is completed.

2. Veeam Explorer for Microsoft SQL Server sends an export 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 staging Microsoft SQL Server machine. For more information, see How Mounting Works.
4. The Veeam SQL Restore Service saves data from the mounted file system to the C:\Windows\TEMP directory on the staging Microsoft SQL Server machine. This step helps convert the data into the necessary format before data transfer.
5. The Veeam SQL Restore Service sends the staged data to the machine where Veeam Explorer for Microsoft SQL Server is opened. Data transfer is established by data movers running on the staging server and the target machine.

After the export operation successfully completes, Veeam Explorer for Microsoft SQL Server unmounts the mounted file system and removes the staged data from the staging server.