Veeam File Level Restore Stuck In Stopping State

When restoring a file in Veeam Backup and Replication 6, the restore can sometimes get stuck and simply says stopping. If Veeam’s file level restore gets stuck in the stopping state, do the following:

1. Download and install SQL Server Management Studio from Microsoft
2. Open SQL Server Management Studio and connect to the Veeam Backup and Replication database (The SQL instance is typically called VEEAM
3. Expand Databases
4. Right click on the VeeamBackup databases
5. Click New Query
6. Make sure that no backups or restores are currently running (other than the stuck job)
7. Paste the following SQL command:
   

   UPDATE [ReportRestoreSessionsAndTaskSessionsView]
   SET “state” = -1
   WHERE “initiator_name” not like ‘null’

8. Pres F5 to execute the SQL query

Veeam reports a stuck file level restore in the stopping state when the software’s front end becomes misaligned with the SQL backend. This SQL query essentially tells Veeam that it should report all jobs as complete, realigning Veeam Backup and Restore with the backend SQL database. In otherwords, the job isn’t really stuck, it’s actually completed, but Veeam incorrectly reports it as stopping.