FileLevelRestore on stopping state

[nreutemann]

Hello,

I try to do a file level restore and the process become inresponsive.
So, I try to stop the job. The job pass to "stopping" state and stay there, from 2 hours ago.
I restart de Veeam B&R server, and the problem remains.
If I try to start a new file level restore job, this new job fail.

Veeam B&R Version 6.1.0.181 64 bit, w2008 R2 Server.

Thanks in advance.

[Vitaliy S.]

Nicolas, please contact our support team (as it is advised when you click New Topic) with all technical issues you may have, as it is hard to troubleshoot your issue without seeing full log files. Thanks!

[nreutemann]

Nicolas, please contact our support team (as it is advised when you click New Topic) with all technical issues you may have, as it is hard to troubleshoot your issue without seeing full log files. Thanks!

Ok, thanks Vitaly.

I put the question here first, because I think maybe there is a easy solution to the issue.

Thanks.

[nreutemann]

Following the KB1534 resolve my issue.

*-*-*-*-*

To fix this you will need to run a SQL query against the VeeamBackup Database, instructions are as shown below.

Before running this SQL query against the “VeeamBackup” Database, please make sure that there are currently no jobs running. If you are unaware of how to run a query against a DB please read the steps below, if you are aware please disregard.

1. Open up SQL Server Management Studio and connect to the VEEAM instance.
2. Expand “Databases”.
3. Right-click “VeeamBackup”>New query.
4. Paste the query below into the query window and hit either “execute” or F5.

The SQL Query:
UPDATE [ReportRestoreSessionsAndTaskSessionsView]
SET "state" = -1
WHERE "initiator_name" not like 'null'

[Dotcommie]

Before running this SQL query against the “VeeamBackup” Database, please make sure that there are currently no jobs running.

How do you run the query if Veeam is constantly in a state of Running? That's actually what he (and I) are trying to fix. Does it not count as Running if it is Stopping? It still shows up as Running.

[Vitaliy S.]

Hi Rick, I believe Nicolas meant that you do not have other jobs running, as SQL script will reset all active sessions on the backup server. Thank you!