How to turn on verbose logging for LiteSpeed Log Shipping plans when additional info is needed for troubleshooting.
WORKAROUND:
Enable logging for log shipping (verify the log shipping plan ID from the LiteSpeed Local)
To enable logging on the Publisher:
» Run the following:
LogShipping_Update_PrimaryDatabase
@PlanID = N'33b3c299-04d6-452c-9858-bb735d37a5e1',
@BackupLoggingLevel = 2
To enable logging on the Subscriber:
» Run the following:
LogShipping_Update_Subscriber
@PlanID = N'33b3c299-04d6-452c-9858-bb735d37a5e1',
@RestoreLoggingLevel = 2
NOTE:
The log is a text file and will be named similarly to: SLS_1_5_2010-8_26_48-AM_3664.Log
The location of the log is determined by the path in the HKEY_LOCAL_MACHINE\SOFTWARE\Imceda\SQLLiteSpeed\Engine\ErrorLogPath
The default is: C:\Documents and Settings\All Users\Application Data\Quest Software\LiteSpeed.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center