In Backup Manager (LiteSpeed Activity) page and record type "Backup", column information contains database, activity, start time, duration, status, backup size, native size, db size, compression. Similar information is not available for restore and copy jobs under Job Manager (Show History) and Log Shipping (History) pages.
How can this information be extracted for reporting purposes?
WORKAROUND
To generate the activity report for the LiteSpeed log shipping backup, copy, and restore jobs, do the following:
1. Run the attached LogBackupHistory.sql using Query Analyzer or Management Studio from the publisher instance using LiteSpeedLocal repository
2. Run the attached CopyRestoreHistory.sql using Query Analyzer or Management Studio from the subscriber instance using LiteSpeedLocal repository
STATUS
Fixed in a future release of LiteSpeed for SQL Server.
