Discussions specific to the VMware vSphere hypervisor
Post Reply
nreutemann
Enthusiast
Posts: 47
Liked: 6 times
Joined: Mar 06, 2012 11:45 pm
Full Name: Nicolas Reutemann
Contact:

FileLevelRestore on stopping state

Post by nreutemann » Jul 05, 2012 4:22 pm

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.
Product Manager
Posts: 23171
Liked: 1600 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: FileLevelRestore on stopping state

Post by Vitaliy S. » Jul 05, 2012 5:35 pm

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
Enthusiast
Posts: 47
Liked: 6 times
Joined: Mar 06, 2012 11:45 pm
Full Name: Nicolas Reutemann
Contact:

Re: FileLevelRestore on stopping state

Post by nreutemann » Jul 05, 2012 6:14 pm

Vitaliy S. wrote: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
Enthusiast
Posts: 47
Liked: 6 times
Joined: Mar 06, 2012 11:45 pm
Full Name: Nicolas Reutemann
Contact:

Re: FileLevelRestore on stopping state

Post by nreutemann » Jul 05, 2012 6:26 pm

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
Lurker
Posts: 2
Liked: never
Joined: Aug 20, 2013 12:11 pm
Full Name: Rick J
Contact:

Re: FileLevelRestore on stopping state

Post by Dotcommie » Sep 10, 2013 4:43 pm

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.
Product Manager
Posts: 23171
Liked: 1600 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: FileLevelRestore on stopping state

Post by Vitaliy S. » Sep 10, 2013 9:05 pm

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!

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests