Veeam File Level Restore Stuck In Stopping State

IT Support Forum Forums Backup and Restore Veeam Backup and Replication Troubleshooting Veeam File Level Restore Stuck In Stopping State

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 3 years ago.

  • Author
    Posts
  • #551

    Webmaster
    Keymaster

    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.

You must be logged in to reply to this topic.