Veeam Explorer for SQL Server Select Database Objects Error

[bpayne]

Veeam v9.0.0.1491
SQL Server Version 2012

Having an issue restoring a table using Veeam Explorer for SQL Server. Im able to launch the explorer, then choose Restore Schema and Data, I get to the window "Select Database objects" and I get a generic error \\servername\C$\VeeamFLR\servername_604253cb\Volume15\DB1\mnt\DB1.mdf. The only option is OK and nothing happens. Only option is to close out and start over. Looking for ideas. I did call Veeam support and open an SR 01833102 but I am waiting for a call back and hope to get some feedback.

I did try choosing a different staging server and that gave me the same type popup error.

Thank you.

[Dima P.]

Hi bpayne,

Can you provide a screenshot of the error you get? Thanks.

[bpayne]

Sorry cant find an easy way to post a picture inline, just a link. I did post a screenshot in the case number.

I did get a call back from support and it looks like the issue is related to this particular sql server has mount points that hosts all the DB's. When Veeam tries to get the tables it just errors out. Support suggested installing the Veeam console on the SQL server itself and we tried again, same issue. We were never able to get it to work. Support then thought it could be a combination of that and a timeout value issue. When extending the timeout value, it did not help. So that is where we are at now. Does Veeam not support getting/restoring tables from mount points on windows server? I have a few servers like that now and has me a bit worried in terms of not being able to use the table restore feature.

[bpayne]

Hi, I'm having some trouble getting an official response about restoring sql tables to windows mount points are supported by Veeam? Thanks

[foggy]

Mount points should be ok, provided remote links are allowed on the server initiating the restore. Are you able to restore/export the entire database?

[bpayne]

Could you please elaborate what you mean by remote links?

The tech I was working with suggested that it could be Data Domain being the issue. I have tried this same type of table restore using HP server storage failing with the same error.

[foggy]

Symbolic links used to specify paths to databases (if it is the case in your setup):

Code: Select all

fsutil behavior query SymlinkEvaluation

Have you tried the entire database restore or export?

[bpayne]

Here are the results of that command. Does any of this stand out to you?

local to local symbolic links are enabled
local to remote symbolic links are enabled
remote to local symbolic links are disabled
remote to remote symbolic links are disabled

I have not tried an entire database restore or export. The feature that I am interested in is the Table restore and I can't even get to a point of displaying the tables to choose. It errors out before that. Thanks

[foggy]

Please try to enable remote links:

Code: Select all

fsutil behavior set SymlinkEvaluation R2R:1
fsutil behavior set SymlinkEvaluation R2L:1

I've asked you about entire database restore as if the reason is indeed disabled links, there would be a more descriptive error on the restore failure event.

[bpayne]

After enabling remote links, I tried the database table restore again. I did receive the same error when trying to pull up a list of tables to check to restore (same as before).

I have tried an FLR restore successfully. But I am not able to perform a full database restore as the database itself is more than 1TB and its a risky operation for being a tier 1 server of ours. I was hoping to for other suggestions rather than resorting to a full database restore

[foggy]

Please continue working with your support engineer on this, case escalation will probably be required.