Video: How to activate Trace logging, Advanced logging (4353530)

Video: How to activate Trace logging, Advanced logging

How to activate Trace logging, Advanced logging?

 

Please see video below:

Method 1:
1) First you need to bring up you registry editor by running the regedit command.
2) From HKEY_Local_Machine> Software> Imceda> SQLLitespeed> Engine
3) Create a multi-string (REG_MULTI_SZ) Value. Named it to trace
4) In the value, enter: Domain=SLS:default
5) Click ok when you are done.
6) The log file will be written to the location pointed by the ErrorLogPath.
By default - C:\Documents and Settings\All Users\Application Data\Quest Software\LiteSpeed\SQL Server

Please Note, putting the instruction in the registry is a global setting. All LiteSpeed backups will generate the advance logging unless overridden by parameters in Method 2 and Method 3.

Method 2:
Using the @trace parameter in the t-sql command.

example:
exec master.dbo.xp_backup_database
@database = N'Northwind',
@backupname = N'Northwind - Full Database Backup',
@compressionlevel = 2,
@filename = N'F:\Backup\Northwind.bak',
@init = 1,
@trace = 'Domain=sls:default',
GO

Method 3:
Using the --trace parameter in the command line script.

example:
SQLLitespeed.exe --Trace Domain=sls:default -B "Database" -D "Northwind" -n "Northwind - Full Database Backup" -C "2" -F "F:\Backup\Northwind.bak" -I "1" -S "<serverName>"

All trace files are generated in the ErrorLogPath location, as per normal LiteSpeed logging.
The @logging parameter will override Trace Logging and should be de-activated.

Unless requested otherwise, the default value should be Domain=all:default. Dev may request other parameters and values to be used, especially when troubleshooting OLR which can be highly verbose.