TRY NOW
book meeting
BACK TO KB LIST

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

KB ID: 4438
Product: Veeam Backup & Replication | 12 | 12.1 | 12.2 | 12.3 | 12.3.1 | 12.3.2 | 13 | 13.1
Published: 2023-05-02
Last Modified: 2025-03-11
mailbox
Get weekly article updates
By subscribing, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.

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

error icon

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:

  1. 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).
  2. 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
4438 sqllogs
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
  1. 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...)
  2. Copy the script to C:\temp\ on the computer where Veeam Plug-in for Microsoft SQL Server is installed.
  3. 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
  1. The script executes simple select queries to gather information; no system changes are made.
  2. The script will create a log bundle and export it to C:\ProgramData\Veeam\Veeam_Case_Logs.
  3. Attach the generated log bundle to the support case.
     

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

log collection

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:

  1. ZIP the contents of the following folder:
    (The programdata folder is hidden by default. Copy and paste the provided path)
%programdata%\Veeam\Backup\MSSQLPluginLogs
  1. 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.
  2.  Export SQL Logs in .csv format and archive them in a ZIP file.
     

Attach all the ZIP files to the support case.

 

More Information

Related Articles

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

If this KB article did not resolve your issue or you need further assistance with Veeam software, please create a Veeam Support Case.

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!

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.

KB Feedback/Suggestion

This form is only for KB Feedback/Suggestions, if you need help with the software open a support case
By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.
Verify your email to continue your product download
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Start using Veeam:
Download the product
&
Activate the license key
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

error icon

Oops! Something went wrong.

Please, try again later.