Monitor server instance can be added by checking the “Use a monitor server instance” checkbox, and specifying server parameters in the “Log shipping monitor settings” dialog, accessed via the “Settings” button
![apex sql server logs apex sql server logs](https://windows-cdn.softpedia.com/screenshots/Apex-SQL-Log_10.png)
If the backup folder is not on the primary server, this field should remain empty
#Apex sql server logs full#
![apex sql server logs apex sql server logs](https://i.stack.imgur.com/VGTXA.png)
If you want to make a backup of the database and transaction log files, you may need to consider HA/DR technologies, such as Always on availability groups, database mirroring, etc. For more detailed information, you may need to use some third-party tools, such as ApexSQL Log. SQL Server provides a command DBCC LOG to read the log file, but the result is not intuitive. So if you want to monitor user behavior, you still have to open SQL Server's own monitoring tools, such as SQL Trace or XEvents, Audit. The blog you provided introduces the use of Audit to record changes to the database and ingesting SQL Server Audit events into Azure Sentinel.īecause SQL Server transaction log positioning is not for user behavior monitoring and recording, but to ensure transaction consistency under the premise of minimal impact on performance, the content it records is for database services, not for users. Are you talking about the SQL Server database transaction log itself, this may not be possible using Azure Sentinel.