Veeam Support Knowledge Base
How to Collect Logs for Veeam Plug-in for Microsoft SQL Server

How to Collect Logs for Veeam Plug-in for Microsoft SQL Server

Q: Automated Log Collection

Download the Log Collection script from the VeeamHub:https://raw.githubusercontent.com/VeeamHub/powershell/master/VeeamPluginforMSSQL-Logs/SQL_Plugin_KB.ps1 (right-click the hyperlink link and click Save link as...) Copy the script to C:\temp\ on the computer where Veeam Plug-in for Microsoft SQL Server is installed. Open an Administrative Command Prompt or PowerShell window and run the following command:Remember to update the command with the path to the script. PowerShell.exe -ExecutionPolicy ByPass -File C:\temp\SQL_Plugin_KB.ps1 Copy The script executes simple select queries to gather information; no system changes are made. The script will create a log bundle and export it to C:\ProgramData\Veeam\Veeam_Case_Logs. Attach the generated log bundle to the support case. If the script fails, please collect the logs manually, as outlined in the section below. The script automatically gathers the following information: Veeam Plug-in for Microsoft SQL Server log files located in C:\ProgramData\Veeam\Backup\MSSQLPluginLogs Windows Application, System, Security, SMB, and Windows FailoverClustering events Native SQL_Err_Log_Folder log folder.

KB ID:	4438
Product:	Veeam Backup & Replication \| 12 \| 12.1 \| 12.2 \| 12.3 \| 12.3.1
Published:	2023-05-02
Last Modified:	2025-03-11

Cheers for trusting us with the spot in your mailbox!

Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest

Oops! Something went wrong.

Please, try again later.

Purpose

This article explains how to collect the logs required for a support case involving Veeam Plug-in for Microsoft SQL Server.

Solution

Quick Start Automated Veeam Plug-in for Microsoft SQL Server Log Collection

If the Windows machines where Veeam Plug-in for Microsoft SQL Server is installed has an internet connection:

Open an Administrative PowerShell console.
_{Tip: Right-click the start button, and from the context menu that appears, select Windows PowerShell (Admin) or Terminal (Admin).}
Run these two lines to automatically download the log collection script to %temp% and execute it.
_{Tip: If you hover your mouse over the code block below, a Copy button will appear in the top-right corner that can be used to copy the script to your clipboard.}

Invoke-WebRequest https://raw.githubusercontent.com/VeeamHub/powershell/master/VeeamPluginforMSSQL-Logs/SQL_Plugin_KB.ps1 -OutFile $Env:Temp\SQL_Plugin_KB.ps1
PowerShell.exe -ExecutionPolicy ByPass -File $env:temp\SQL_Plugin_KB.ps1

When the script is complete, answer Yes to have the script open the folder where the logs were written, then attach the log bundle to the case.

If the machine where Veeam Plug-in for Microsoft SQL Server is installed cannot access the internet or the location where the script is stored, download the script on another machine and copy it to that machine.

You may collect logs in the following ways:

Automated Log Collection

Download the Log Collection script from the VeeamHub:
https://raw.githubusercontent.com/VeeamHub/powershell/master/VeeamPluginforMSSQL-Logs/SQL_Plugin_KB.ps1
(right-click the hyperlink link and click Save link as...)
Copy the script to C:\temp\ on the computer where Veeam Plug-in for Microsoft SQL Server is installed.
Open an Administrative Command Prompt or PowerShell window and run the following command:
^{Remember to update the command with the path to the script.}

 PowerShell.exe -ExecutionPolicy ByPass -File C:\temp\SQL_Plugin_KB.ps1

The script executes simple select queries to gather information; no system changes are made.
The script will create a log bundle and export it to C:\ProgramData\Veeam\Veeam_Case_Logs.
Attach the generated log bundle to the support case.

If the script fails, please collect the logs manually, as outlined in the section below.

The script automatically gathers the following information:

Veeam Plug-in for Microsoft SQL Server log files located in C:\ProgramData\Veeam\Backup\MSSQLPluginLogs
Windows Application, System, Security, SMB, and Windows FailoverClustering events
Native SQL_Err_Log_Folder log folder.

Manual Log Collection

On the computer where Veeam Plug-in for Microsoft SQL Server is installed, collect logs from the following 3 places:

ZIP the contents of the following folder:
^{(The programdata folder is hidden by default. Copy and paste the provided path)}

%programdata%\Veeam\Backup\MSSQLPluginLogs

Export Event Logs in EVTX format with Display Information for the following logs.
- Application
- Security
- System
- Microsoft > Windows > SMBClient > Connectivity
- Microsoft > Windows > SMBClient > Operational logs
- Microsoft > Windows > FailoverClustering (If present)
Combine the exported EVTX files and the LocaleMetaData folder in a single ZIP file.
Export SQL Logs in .csv format and archive them in a ZIP file.

Attach all the ZIP files to the support case.

More Information

For more information on how we process the collected data, please visit: vee.am/processing_of_personal_data

To submit feedback regarding this article, please click this link: Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.

Spelling error in text

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please, try again later.

You have selected too large block!

Please try select less.

How to Collect Logs for Veeam Plug-in for Microsoft SQL Server

Cheers for trusting us with the spot in your mailbox!

Oops! Something went wrong.

Purpose

Solution

Quick Start Automated Veeam Plug-in for Microsoft SQL Server Log Collection

More Information

Related Articles

Spelling error in text

Thank you!

Oops! Something went wrong.

You have selected too large block!

KB Feedback/Suggestion

Thank you!