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'?
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.
