The LiteSpeed backup job on one of my servers has been failing the past 6 days. I have verbose logging enabled and am able to see where the error is occurring.
Following files have been deleted: \\backupserver\sqlbackup\TEST\server\SFVIEWS_MIRROR\SFVIEWS_MIRROR.litespeed.f11.d9.bkp [SQLSTATE 01000]Msg 50032, Sev 16, State 1: Failed to remove file '\\backupserver\sqlbackup\TEST\server\SFVIEWS_MIRROR\SFVIEWS_MIRROR.litespeed.f11.d5.bkp' (Error 32) [SQLSTATE 42000]
The error [SQLSTATE 42000] indicates that it is a syntax error or access violation.
Based on the logs I'm seeing that the service account being used to run the backup job is able to remove other files with no issue however the file 'SFVIEWS_MIRROR.litespeed.f11.d5.bkp' has errored each day.
Does anyone have any tips for this issue? Can I remove this file manually without breaking the LiteSpeed job?
In reply to ben:
In reply to a.dang: