During the first run of the SQL Transaction Log Backup, it evaluates the available free space of all volumes on the SQL machine where it is operating. The disk with the most free space is selected as the location where transaction log backup files will be temporarily stored before being copied to the repository. Once the software determines the drive and path it will utilize, it records this information in the registry value named SqlTempLogPath.
To manually configure the location, modify the SqlTempLogPath registry value on the SQL server that is being backed up.
Key Location: HKLM\SOFTWARE\Veeam\Veeam Backup and Replication
Value Name: SqlTempLogPath
Value Type: String Value (REG_SZ)
Value Data: < Path to the desired location, without a trailing backslash. >
Invalid Path Handling
As long as the original path remains valid, the software will not alter the path recorded in the registry. However, if the path recorded in the SqlTempLogPath registry value becomes invalid, the software will automatically select a new path, opting for the drive with the most free space. If this occurs, the SqlTempLogPath registry value will be updated.