Veeam support provided a SQL script and instructions to reset a job. I'm not sure if it only applies to FileLevelRestore locked state (i.e.the value of 'state' and/or 'overall_status')
- Code: Select all
update [BSessions] set overall_status = 0 where overall_status <> 2
update [BJobs] set control = 0
update [ObjectsInBackups] set [state] = 0 where [state]=2 or [state]=3
1. Save JobsReset.sql file to local disk on Veeam server.
2. Make sure that there are no jobs running to avoid resetting their status accidentally.
3. Run the following command: sqlcmd -S COMPUTER\INSTANCE -d VeeamBackup -i PATHTOSCRIPT\JobsReset.sql
where COMPUTER is the name of computer with database, INSTANCE is the name of instance (VEEAM for default installation), PATHTOSCRIPT is the path to the JobsReset.sql script.
After running this, restart both the SQL Service for Veeam (VEEAM), and the Veeam Backup Scheduling Service. (in that order)
One of the Veeam product managers will put me right if this a bum steer!