https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IyNjQyIiwiaGFzaCI6IjUyNGFlODVkLTZlMzYtNDQ2Ny05MjA1LWI5OWExNzZmODRhZCJ9
1-800-691-1991 | 9am - 8pm ET
EN

How to change SQL log backup location for Veeam Agent for Microsoft Windows backup

Challenge

This article documents how change the temporary staging location where SQL transaction log backups are stored during a Veeam Agent for Windows backup operation when Transaction Log Backup is enabled.

For more information on the Transaction Log Backup process for Veeam Agent for Windows please click here.

Cause

When SQL Transaction Log Backup is enabled, Veeam Agent for Windows copies transaction log files from the log archive destination (set by the Microsoft SQL Server administrator) to a temporary folder on the server. By default the path is: C:\ProgramData\Veeam\Endpoint\SqlLogBackup.

Solution

To change the location where the SQL Transaction Logs are temporarily stored, create the following registry entry on the server.

Note: This registry change is to be made on the machine where Veeam Agent for Windows is installed, and is running the backup with SQL Transaction Log backup enabled.


Key: HKLM\SOFTWARE\Veeam\Veeam Endpoint Backup
Type: REG_SZ (String Value)
Name: SqlTempLogPath
Value: Path to desired location (without trailing backslash)

Note: if the backup job is managed by Veeam Backup & Replication, then the path for the registry should be:

Key: HKLM\SOFTWARE\Veeam\Veeam Backup and Replication

The key should be created manually in the Agent machine registry if it does not exist.

Example

More information

  • For managed by VBR Failover Cluster type jogs the path should be HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup and Replication. The key should be created manually in the Agent machine registry if it does not exist.
  • Starting with Veeam Backup and Replication 9.5 Update 4 (Veeam agent for Windows 3.0.1.1039) if the entered path is not valid, Veeam Agent will select an NTFS/ReFS volume having the most free space.
KB ID:
2642
Product:
Veeam Agent for Microsoft Windows, Veeam Backup & Replication
Version:
VAW 2.1
Published:
2018-04-27
Last Modified:
2020-09-16
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later