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'
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center