Veeam installs Veeam SQL Restore Service runtime component on the VM guest OS (target or staging server, depending on selected restore or export scenario) to support restore activities on the SQL server VM guest.
This service is running during the restore session; it checks the rights assignment required for database restore, gets information about databases that should be restored, performs the necessary file operations (including database and transaction log copy) and so on. When restore session ends, the service is stopped and removed from guest. Then a new session starts, and the service is installed again.
- The Veeam SQL Restore Service operates under the Local System account.
- All service activities are logged to the Veeam.SQL.Service_<timestamp>.log file stored in the Temp folder of the system directory, next to the Veeam.SQL.Service_<timestamp>.exe file (runtime component installed per session). If you have enabled extended logging as described in this Knowledge Base article, this log data will be stored in the Veeam Explorer for Microsoft SQL log.
- Communication between Veeam Explorer and the service is performed using RPC; default TCP port range that should be opened on the guest for inbound traffic includes ports 1025 - 1034. If you need to change this port range, do the following:
- Open Veeam Explorer configuration file named Config.xml located at C:\ProgramData\Veeam\Backup\SQLExplorer\on the machine hosting Veeam Explorer (create the file if it is not present).
- Locate the <SQLExplorer> tag (create the tag if it is not present):
<Agent MinimumPort="1025" MaximumPort="1034"/>
- Supply the necessary values for Agent MinimumPort and MaximumPort.
When restoring the database to the local SQL server instance, Veeam SQL Restore Service runtime component is not installed on the SQL server guest OS.