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=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IyMTI1IiwiaGFzaCI6IjM3NTQ3Njg5LTIwNTAtNDQ0ZC1iN2ZhLWI4MmQzNDU5MmM3NyJ9
1-800-691-1991 | 9am - 8pm ET
EN

How to Export SQL Logs

Challenge

Veeam Technical Support has identified that there may be a problem with backing up of the SQL server and/or truncation of the SQL logs. Veeam Technical Support would like to confirm what is configured in SQL and the events that occur during the backup by collecting the SQL logs using SQL Management Studio.

 

Cause

First open Microsoft SQL Management Studio, and login to the instance Veeam Backup and Replication is attempting to backup.
 
Once logged in, expand the [Management] folder in the tree view to the left, then expand [SQL Server Logs]
User-added image

Typically the most current log will be the the most beneficial and it is highlighted in the example above. Double-click this log to open the next dialog box. Look for the [Export] button to generate the log.
User-added image

Please save the resulting log in either .txt format or .csv format.
User-added image

When the export is completed, please copy the new log file to either the FTP account supplied by Veeam Technical Support for the case, or or you can log into the Customer Portal (cp.veeam.com) and attach the logs directly to the your case

 

More information

For documentation on exporting logs from Veeam Backup & Replication please review: https://www.veeam.com/kb1832
For further documentation on exporting Windows Event Logs please review: https://www.veeam.com/kb1873
KB ID:
2125
Product:
Veeam Backup & Replication
Version:
7.x, 8.x, 9.x
Published:
2016-04-13
Last Modified:
2020-08-13
Please rate how helpful this article was to you:
3 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