How to check the progress of a running LiteSpeed backup or restore.
If running backup/restore from script, the parameter STATS [ = percentage ] may be added to the script for an on-screen display of percentage completed.
The LiteSpeed xp_slsReadProgress may be executed via query analyzer for a single (not dynamic) display of percentage completed. The output returns an integer (0-100) indicating the percentage completed of the current activity on the specified database.
Syntax:
EXEC master.dbo.xp_slsReadProgress
@database = { 'database_name' | @database_name_var }
Also see Solution 16734 for additional methods to monitor the progress of a LiteSpeed database restore:
https://support.quest.com/SUPPORT/index?page=solution&id=SOL16734
