Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- How to find default values of all SQL Server columns
- Tcp port is already in use.How do I check if a port is already in use?
- How to find all identity columns in SQL Server
- What is the difference between Always On Clustered and Always On Clusterless
- How do I check my cross DB ownership chaining?
- Disable a SQL Agent Job not working
- What does it mean when a file is modified?
- How can I check SQL Agent Job current status ?
- How to enable SQL Server trace flags at startup
- SQL Server user roles and permissions query
How to view SQL Server logging on Linux
18 March,2021 by Tom Collins
Question: How can I view SQL Server Logging on Linux ?
Answer: SQL Server on Windows - logs details into SQL Server Error logs and Application Logs. Windows event viewer details are available in the Windows Event Logs via the event viewer or Powershell Get-EventLog
1) SQL Server logs details in the SQL Server error log file and the Linux log usually , /var/opt/mssql/log/
2) Use the journalctl command
--show all the log messages since last reboot
journalctl -b
--list by boot number, step 1 generate list of boot numbers. Use the index number (the first column) from command 1 as input parameter for command 2
journalctl --list-boots
0 0461cc4f0702412297c62e0b1834db02 Mon 2021-03-08 21:32:29 GMTâThu 2021-03-18 1
journalctl -b 0
The data is stored on different log files. If you want to view the data file locations of where the Linux source log files are stored read man systemd-journald on your Linux system
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |