Comprehensive data protection for all workloads
Post Reply
puderbaer
Novice
Posts: 7
Liked: 2 times
Joined: Sep 13, 2013 10:59 am
Full Name: Uwe Sachse
Contact:

Sharepoint Restore of Filestream document

Post by puderbaer » Sep 30, 2013 12:54 pm

Hello together,

I'm trying to restore a single item using Sharepoint explorer in VEEAM 7. As long as the document is located inside the database, everything works fine and the restore succeeds. But we are also running some DBs with filestream / Blobstore option enabled, in order to keep the databases small and store larger files outside in a folder. When I try to restore such a document, I always get the error message:

No provider of type <filestream> found. Check the server configuration or install provider on the client.

I have filestream support enabled on the Staging SQL Server where VEEAM B&R is installed. I also installed RBS Tools on the system. Has anybody successfully restored a Sharepoint document yet that is located in a Blobstore?

Thank you in advance

Dima P.
Product Manager
Posts: 10715
Liked: 881 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Sharepoint Restore of Filestream document

Post by Dima P. » Sep 30, 2013 1:04 pm

Hello Uwe,

Could you please confirm that RBS Tools you installed, are up to date and include latest hotfixes? Thank you.

puderbaer
Novice
Posts: 7
Liked: 2 times
Joined: Sep 13, 2013 10:59 am
Full Name: Uwe Sachse
Contact:

Re: Sharepoint Restore of Filestream document

Post by puderbaer » Sep 30, 2013 2:14 pm

Hello Dimitry,

yes, RBS Tools are up to date. I tried to restore the SharePoint item on two different Staging Servers, one with SQL 2008 and the other with SQL 2012 running. I installed the corresponding versions of RBS tools. The original SharePoint Database Server runs on SQL 2008 Version, SharePoint Version is 2010 Foundation. I'm wondering if I have to install some other SharePoint components on the staging server.
Best regards
Uwe

Dima P.
Product Manager
Posts: 10715
Liked: 881 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Sharepoint Restore of Filestream document

Post by Dima P. » Sep 30, 2013 2:34 pm

Uwe,

Please, take a look at this blog thread - I believe this issue is related to .Net framework updates/ missing components?

foggy
Veeam Software
Posts: 18458
Liked: 1589 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sharepoint Restore of Filestream document

Post by foggy » Sep 30, 2013 2:59 pm

Uwe, is the BLOB storage located on the same server where the main SharePoint database being backed up is located?

foggy
Veeam Software
Posts: 18458
Liked: 1589 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sharepoint Restore of Filestream document

Post by foggy » Oct 01, 2013 11:19 am

Looking further, the issue seems to be caused by the staging SQL server configuration, so you would probably get the same error while trying to save the file to disk instead of restoring it. To be able to restore objects stored in RBS, the following should be done on the staging SQL server:

1. FILESTREAM options should be enabled in the SQL Server properties in SQL Server Configuration Manager.
2. The following query should be executed:

Code: Select all

EXEC sp_configure filestream_access_level, 2
RECONFIGURE
3. Client and FILESTREAM Provider > Client options should be enabled while installing RBS API.

You can install RBS API from here (works fine in our lab environment).

puderbaer
Novice
Posts: 7
Liked: 2 times
Joined: Sep 13, 2013 10:59 am
Full Name: Uwe Sachse
Contact:

Re: Sharepoint Restore of Filestream document

Post by puderbaer » Oct 01, 2013 12:28 pm

Hello,

first of all thank you very much for the great and quick support.

- yes, the BLOB storage folder is located on SharePoint database server
- I enabled Filestream option and reconfigured filestream access level by executing the script.
- I tried both BLOB providers 2008 R2 annd 2012 (RBS.msi)
- select client and Filestream provider during setup


The errormessage in log is:

Error: Could not load file or assembly 'Microsoft.Data.SqlRemoteBlobs, Version=10.50.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx' (edited) or one of its dependencies. The system cannot find the file specified.

foggy
Veeam Software
Posts: 18458
Liked: 1589 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sharepoint Restore of Filestream document

Post by foggy » Oct 01, 2013 1:02 pm

I suggest you to contact technical support so they could take a closer look at your logs.

Kellen.Flood
Enthusiast
Posts: 49
Liked: 3 times
Joined: Apr 19, 2013 8:30 pm
Full Name: Kellen Flood
Contact:

Re: Sharepoint Restore of Filestream document

Post by Kellen.Flood » Nov 20, 2013 6:08 pm

hey foggy,

Has Veeam support resolved this issue?

veremin
Product Manager
Posts: 17075
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Sharepoint Restore of Filestream document

Post by veremin » Nov 21, 2013 8:49 am

Hi, Kellen,

Have you already tried the procedure mentioned by Alexander that includes enabling Filestream option and executing certain query?

Thanks.

foggy
Veeam Software
Posts: 18458
Liked: 1589 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sharepoint Restore of Filestream document

Post by foggy » Nov 21, 2013 9:50 am

And since there's no support case ID in this thread, we cannot track down the resolution.

Ben.Pierson
Novice
Posts: 7
Liked: 1 time
Joined: Feb 13, 2012 5:22 pm
Full Name: Ben Pierson
Contact:

Re: Sharepoint Restore of Filestream document

Post by Ben.Pierson » Nov 26, 2013 11:38 pm 1 person likes this post

Just to chime in here in case somebody else has this issue, that case number was 00453588. As far as I can tell from the case notes (originally in German), the issue seems to have self resolved on a later run of the job. Is it possible that any of the recommended changes require a reboot he was missing on the first attempt?

foggy
Veeam Software
Posts: 18458
Liked: 1589 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sharepoint Restore of Filestream document

Post by foggy » Nov 28, 2013 12:52 pm

Ben, in our internal testing reboot was not required.

jluce
Enthusiast
Posts: 25
Liked: 3 times
Joined: Jan 14, 2015 2:23 am
Full Name: John Luce
Contact:

[MERGED]: How to correctly backup/restore SQL filestream fil

Post by jluce » Jan 11, 2016 2:17 pm

We ran into a problem when we were looking at restoration of a MS SQL database that has filestreaming set up on it. The Veeam documentation tends to talk about SharePoint in regards of using filestreamed databases. However we have a filestreamed database that is in use with a SQL app and we were wondering how to best backup and restore it? An attempt to restore a filestreamed database was made over the week-end but failed. Upon review, that was most likely due to the fact the staging server isn't setup for filestreaming and probably should be. Looking for guidance on how best to handle this.

PTide
Product Manager
Posts: 5349
Liked: 471 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Sharepoint Restore of Filestream document

Post by PTide » Jan 11, 2016 5:28 pm

Hi,

It's hard to say what was the root cause of failure without log details. Please first review the thread and double-check that you're on the latest update. If the problem persists then please open a case with our support team so they can take a closer look at your environment, and post you case ID in this thread.

Thank you.

jluce
Enthusiast
Posts: 25
Liked: 3 times
Joined: Jan 14, 2015 2:23 am
Full Name: John Luce
Contact:

Re: Sharepoint Restore of Filestream document

Post by jluce » Apr 06, 2016 6:59 pm

Sorry about not following up here. The issue ended up in Tier 3 support. It turned out that in v8 the account being used for SQL services on this SQL instance did not did not have administrative access to the file system, so if it did not matter that the account being used to perform the restore had access to the OS when it tried to mount the filestream files it would fail. We are told this has been worked out in version 9 which we have recently deployed but not come back around full circle to test.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 64 guests