- Veeam Support Knowledge Base
- How to Export SQL Logs
How to Export SQL Logs
| KB ID: | 2125 |
| Product: | Veeam Backup & Replication | 7.0 | 8.0 | 9.0 | 9.5 | 10 | 11 | 12 | 12.1 | 12.2 | 12.3 | 12.3.1 | 12.3.2 | 13 | 13.1 |
| Published: | 2016-04-13 |
| Last Modified: | 2023-10-27 |
Get weekly article updates
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 documents how to export logs from the two SQL database engines used by Veeam Backup & Replication:
- Microsoft SQL Server
- PostgreSQL
Solution
Microsoft SQL Server Log Collection
The following steps require Microsoft SQL Server Management Studio (SSMS).
- Open Microsoft SQL Server Management Studio and connect to the SQL Instance for which SQL Server Logs are needed.
- Once connected expand the [Management] ➔ [SQL Server Logs] and double-click on the entry named Current
- Within the Log File Viewer, select "Current" and any "Archive" entries that cover the dates that logs are needed for.
- Click [Export] to save the logs to a file.
Note: All three file type options for Exporting generate the same file content with a different extension (i.e. log, csv, or txt).
PostgreSQL Log Collection
By default, PostgreSQL logs are written to the following folder:
C:\Program Files\PostgreSQL\15\data\log
Collect logs with timestamps that cover the dates that logs are needed for.
More Information
For documentation on exporting logs from Veeam Backup & Replication please review: https://www.veeam.com/kb1832
For documentation on exporting Windows Event Logs please review: https://www.veeam.com/kb1873
For documentation on exporting Windows Event Logs please review: https://www.veeam.com/kb1873
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.
