How to Export SQL Logs

KB ID: 2125
Products: Veeam Backup & Replication
Version: 7.x, 8.x, 9.x
Published:
Last Modified: 2016-04-20

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

 

Solution

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
5 / 5 (7 votes cast)

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!

Orphus system