BEST Practices for File Level Restore cancelling job?

[stuartmacgreen]

Several times I (Veeam B&R Administrator) have had to intervene when my backup operations personnel have issued a file restore (from Backup Enterprise Manager) and they then wished the restore to be cancelled/stopped.

I go to the Veeam backup server with the veeam backup GUI and issue Stop Session on that restore.

It thereafter sits in Stopping state for ages. The BEM under Files tab still shows 'Restore in progress'

I intervene (or patience runs out) when I then have to go into SQL Management Studio and issue the SQL statement that resolves the problem as in this KB
http://www.veeam.com/kb1534

I had a worse problem in the early days when the operator just kicked off the same restore while the other restore in stopping state and I had a support case to fix my database as there was a couple of tables needed updated/fixed. So I now ask the backup operators to wait until I fixed the stopping issue first.

Q: Is there a proven practice for carrying out a cancel of a FLR active job, that results in it stopping successfully - every time.?

Thanks

Running Veeam B&R 7.00.839 (Windows 2008 R2)

[wa15]

I actually have the same issue and would like to know of a fix. Running v 7.0.0.771 on a Windows 2012 server. The fix in our case is manually killing the Veeam Backup Service.

[Vitaliy S.]

Hi Stuart,

Normally, you should not see these stuck sessions. I have passed this info to our QC team for further investigation. BTW, do you see the same behavior if you initiate the FLR session from the backup console and not the EM UI?

Thanks for the heads up!

[Vitaliy S.]

Just a short update - our QC team has confirmed the observed the behavior. We are going to address it in the next updates. Thanks again, guys.

[owjeff]

How about just supporting restores while a backup is in progress so we can do away with this cancelling a running backup job nonsense?

[Vitaliy S.]

If this a reversed incremental backup mode and you're trying to restore from the latest point, it will be locked by the backup job. It should not be the case with forward incremental backup mode though (need to double-check).

[wa15]

@Vitaliy, in my case it does happen both from EM UI and from the console. And thanks for the quick response to this issue!! You guys are great.

[Vitaliy S.]

Farshid, when you're trying to stop the FLR session in the backup console, have you tried closing the restore window/restore browser after stopping the session?

[wa15]

I have tried that as well, along with closing the backup console and re opening it.

Also, in one case, when I had a FLR job stuck in stopping state, I rebooted Windows 2012 and Windows ended up just getting stuck in the "Restarting" phase and I had to hard power the server down.

@ Stuart, sorry, didn't mean to hijack the thread.

[Vitaliy S.]

OK, thanks for additional details, I will discuss these cases with the QC team as well.

[KurtL]

Any news about this issue?
I'm experiencing the same in the BEM.
Two jobs with status "Restore in progess" like for 5 months.
The same jobs are showing the correct status in the console.
Running VEEAM 7 patch 3

[foggy]

Like Vitaliy has stated above, this should be addressed in one of the next product updates. And there were no product updates since his post.

[Cranky]

Are there any workarounds until the next update? I have several jobs showing in BEM that are 100% complete but still show "Restore in Progress". The GUI reports the restore jobs as "Success".
I've tried the fix in here http://www.veeam.com/kb1534, restarted all Veeam and SQL services.

[foggy]

Frank, our support will be able to assist you in clearing those records from the DB. Please contact them directly. Thanks.