The backup job failed, the backup job was restarted manually, and completed, with the backup file created on the drive.
However, the statistics from the LiteSpeedLocal or LiteSpeedCentral still show the backup is "IN PROGRESS".
The LiteSpeedActivity table in LiteSpeedLocal has a row with statustypeID = '1' which should have been updated to statustypeID = '2'
WORKAROUND:
1 - IN PROGRESS | 2 - COMPLETED | 3 - FAILED
1.. Get - 1 IN PROGRESS record.
Example:
USE LiteSpeedLocal
SELECT * FROM LiteSpeedActivity
where statustypeID = '1'
2. Perform the update from 1 to 2 (completed.)
Example:
update litespeedactivity set statustypeid = 2
where ServerName = 'Your instance name' and
ActivityID = 'xxx' and
DatabaseID = 'xxx' and
starttime = '2008-10-20 15:46:03.967' and
FinishTime = '2008-10-20 15:46:05.263'
3. Check the update status from the table.
Example:
USE LiteSpeedLocal
SELECT * FROM LiteSpeedActivity
where ServerName = 'Your instance name' and
ActivityID = 'xxx' and
DatabaseID = 'xxx' and
starttime = '2008-10-20 15:46:03.967' and
FinishTime = '2008-10-20 15:46:05.263'
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center