-
Title
hung backup has left status as 'In Progress' indefinitely under the 'LiteSpeed Activity' in the Backup Manager. Way to manually edit? -
Description
If a backup fails to complete it can leave the status as 'In Progress' indefinitely under the 'Backup Status Report' or under the 'LiteSpeed Activity' in the Backup Manager. Further, that status is preventing the next run of that same job. How do we change the status to display as either 'Complete' or 'Failed'?
-
Resolution
If the jobs are hanging, first attempt to stop them from 'Server SQL Agent' | 'Jobs' | select hung job | right click | 'Stop Job'.
If that still doesn't clear those jobs out from the LiteSpeed console, you can manually set the hung LiteSpeed jobs to a completed status.
Information is in LiteSpeedActivity table in both LiteSpeedLocal and LiteSpeedCentral databases. The StatusTypeID is the column to be updated. The values are as follows:
1 - In Progress.
2 - Complete
3 - Failed
Update the field on the LiteSpeedLocal repository only. To do that, run the below SQL statement in the SSMS:
update LiteSpeedLocal.dbo.liteSpeedActivity
SET StatusTypeId=2
WHERE StatusTypeId=3
After you update this field, you need to null the ReplicateID field, if it is not already.
Then navigate to the '...Program Files\Quest Software\LiteSpeedSQL Server\Engine' folder and double click on the 'ActivityManager.exe'. This updates the info from the LiteSpeedLocal to the LiteSpeedCentral. -
Attachments
