To change the log path on the audited SQL Server, perform the following:
- Navigate to the SQL Server Auditing installation directory (by default C:\Program Files (x86)\Netwrix Auditor\SQL Server Auditing).
- Open the “pathstotracelogs.txt” file for editing.
- Populate this file with UNC paths where you want the trace logs to be stored on your SQL Servers.
Syntax: SQLServer\Instance|UNC path
server\instance|C:\Program Files\Microsoft SQL Server\MSSQL\LOG\
Replace ‘SQLServer’ with the SQL server machine name.
Replace ‘Instance’ with the SQL server instance name.