Logging is available for the following areas in LiteSpeed:
NOTE: Log shipping plans activity is also logged and displayed in the History tab of the Log Shipping pane (CTRL+2). See the Configure Log Shipping guide for more information.
Installer log files are created in the default output directory. When you use the Remote Deploy Configuration wizard to deploy LiteSpeed on SQL Server instances, this creates a 'RemoteDeploy'-prefixed log file on the machine where you run the remote deploy from and 'SLSInstall'-prefixed log files on all target servers. For more information, see Log File Naming and Location.
Using the following instructions you can enable logging for a particular backup or restore activity. To log all backup/restore activity on the server, see Instance-Wide LiteSpeed Logging.
To enable backup/restore logging, do one of the following:
LiteSpeed's advanced tracing facility allows for even more granular control over the major LiteSpeed features at the server level.
To enable/disable advanced logging
Right-click an instance in the server tree, select Support and then LiteSpeed Logging.
Select one or more of the following options:
Clear one or more checkboxes to disable advanced logging for those options.
Complete the dialog. Review the following for additional information:
Option | Description |
---|---|
Log file path |
This parameter specifies a path to a default output directory into which the log files are written. For more information, see Log File Naming and Location. |
Flush output to log file after every write (slower) | LiteSpeed will perform a disk flush after each record. Select this parameter if you experience program exceptions resulting in a process abort. |
Delete log file on success | A log file is only saved if an error has occurred during execution. |
Automatically delete log files older than | This will automatically delete log files older than specified number of days |
Log rollover size | This will limit the size of the log file, so that only the last records that fit within the specified size will be kept. Use this option in the case of a long running application, when the log file becomes overly large, or when an error happens near the end of execution. Otherwise, set the rollover size value to zero. |
NOTES:
By default, log files are written to C:\Documents and Settings\All Users\Application Data\Quest Software\LiteSpeed\SQL Server\Logs (or C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs). This location is specified by the logpath value in the LiteSpeedSettings.ini file. (Usually, C:\Documents and Settings\All Users\Application Data\Quest Software\LiteSpeed\SQL Server\LiteSpeedSettings.ini.)
To change the default output directory
Right-click an instance in the server tree, select Support and then LiteSpeed Logging.
Enter a new location in the Log file path field.
Log files will have one of the following formats:
Where source components are the following:
Other components of the log file name are as follows:
When you use the Remote Deploy Configuration wizard to deploy LiteSpeed on SQL Server instances, this creates a 'RemoteDeploy'-prefixed log file on the machine where you run the remote deploy from and 'SLSInstall'-prefixed log files on all target servers.
The LiteSpeed UI Console activity is logged in the Windows Application event log.
To set the LiteSpeed UI Console logging level
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center