Restore Sharepoint content

Availability for the Always-On Enterprise

Restore Sharepoint content

Veeam Logoby LinkeLoe » Sun Dec 15, 2013 6:39 pm

Hi all,

We have a SharePoint 2013 webserver running, with the content and configuration databases on a dedicated, separate database server. Both VM's are included in a single backup job in Veeam 7.0 R2a. Now, I would like to restore SharePoint data directly into the SharePoint environment, but when I open the SharePoint Item restore wizard, I see all the SharePoint sites with an exclamation mark. The message is "SQL Server VM hosting the content database is missing".

How should I set this up in a way I can restore content directly into the SharePoint site? Or do I have to do a file level restore of the content database first?
LinkeLoe
Enthusiast
 
Posts: 35
Liked: never
Joined: Fri Apr 06, 2012 8:31 pm
Full Name: Leo Schroer

Re: Restore Sharepoint content

Veeam Logoby foggy » Sun Dec 15, 2013 8:19 pm

Leo - yes, you should initiate file-level recovery session, start Explorer for SharePoint from there, and point it to the database file. No need to actually restore the database file to disk.
foggy
Veeam Software
 
Posts: 14588
Liked: 1062 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Restore Sharepoint content

Veeam Logoby Gostev » Sun Dec 15, 2013 10:17 pm

You should not have to do all this if both VMs were backed up with application-aware processing enabled... in that case, we will know where to look for the content database, so the SharePoint recovery wizard will just work.
Gostev
Veeam Software
 
Posts: 21364
Liked: 2336 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Re: Restore Sharepoint content

Veeam Logoby LinkeLoe » Mon Dec 16, 2013 6:56 am

Dear both,

Thanks for your (somewhat contradictory) replies...

The error message I get when continuing the restore, states that I need to do a file level restore indeed. However, I assumed it would be possible to do it without a file level restore, like Gostev said.

Both VM's are being backed up application aware. I even added the backup service account to the site owner group of every site, to make sure it has permissions on that site, but that didn't work out either...
LinkeLoe
Enthusiast
 
Posts: 35
Liked: never
Joined: Fri Apr 06, 2012 8:31 pm
Full Name: Leo Schroer

Re: Restore Sharepoint content

Veeam Logoby foggy » Mon Dec 16, 2013 7:32 am

Do you have any warnings related to application-aware processing in the job session? Also, even in case of successful application-aware processing, there might be a failure to collect SharePoint topology (for example, if one of the sites is unavailable for some reason). I recommend contacting technical support to troubleshoot this. And while the investigation is underway, you can utilize the mentioned FLR workaround.
foggy
Veeam Software
 
Posts: 14588
Liked: 1062 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Restore Sharepoint content

Veeam Logoby LinkeLoe » Thu Dec 19, 2013 7:27 pm

Hi...

No I don't have any warnings in the backup job...

I will contact support and create a case for this. Thanks...
LinkeLoe
Enthusiast
 
Posts: 35
Liked: never
Joined: Fri Apr 06, 2012 8:31 pm
Full Name: Leo Schroer

Re: Restore Sharepoint content

Veeam Logoby v.Eremin » Sun Dec 22, 2013 10:36 am

It will be appreciated, if post your ticket number here, so that we could follow the case. Thanks.
v.Eremin
Veeam Software
 
Posts: 13103
Liked: 951 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

[MERGED]: Restoring SharePoint items

Veeam Logoby smcauley » Wed Feb 17, 2016 12:27 am

Morning everyone... We are having an issue when we try to restore SP items. If we go to the SP server backups and try to Restore MS SP content we see an error which says, "SQL Server VM hosting the content database is missing". We also tried using the Veeam Explorer for SP which loads but does not show the content database. As a workaround we can grab the content db and log file from the backup and then attach this in the Explorer to view the content. This is time consuming though and not normal behaviour from what I understand.

The backup jobs for our SQL server and SharePoint server both have application aware processing turned in.

Case number is 01700912.

Appreciate any guidance anyone can give me.
smcauley
Novice
 
Posts: 8
Liked: 2 times
Joined: Tue Jun 28, 2011 6:32 am
Full Name: SIMON MCAULEY

Re: Restore Sharepoint content

Veeam Logoby smcauley » Thu Feb 18, 2016 12:37 am 2 people like this post

Support have come back and resolved my issue. Hopefully this can help someone else in the future.

1. Create HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\SPSToSQLMap\ key (Type: REG_SZ). It should be a sibling to the Veeam Backup and Replication key, not its child.

2.Add String values, where Name is the Sharepoint server NetBIOS name (if NetBIOS doesn't work, try FQDN), and Data = "<SQL_SERVER>\<SQL_INSTANCE>".
E.g. Name = DHPSP1 (or e.g. DHPSP1.domain.local), Data = DHPSPSQL1\SP2013.

3. If you have multiple SQL servers for a single Sharepoint, separate instance names by ; e.g. DHPSPSQL1\SP2013;DHPSPSQL2\SP2013.

4. Add as many as needed if there are multiple Sharepoint servers.

5. Restart Veeam Backup Shell.
smcauley
Novice
 
Posts: 8
Liked: 2 times
Joined: Tue Jun 28, 2011 6:32 am
Full Name: SIMON MCAULEY

Re: Restore Sharepoint content

Veeam Logoby VanillaMastermind » Fri Jun 03, 2016 7:45 pm

I am having a similar issue. Do you make this registry change on the SharePoint APP/WEB servers only, or do you need this on the database servers as well?
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: Restore Sharepoint content

Veeam Logoby foggy » Mon Jun 06, 2016 10:18 am

This is done on the Veeam B&R server.
foggy
Veeam Software
 
Posts: 14588
Liked: 1062 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Restore Sharepoint content

Veeam Logoby mtrx » Mon Jul 11, 2016 1:39 pm

I'm stuck with the same problem.
We are using different Staging server . The only way to do a Single Item restore is to dump the MDF/LDF file to the local disk and start SharePoint Explorer.
If I do a Guest file restore and point both files for SharePoint item level recovery nothing happens .

Imported the Reg key into the B&R server but still the same problem.
Any ideas ?
mtrx
Lurker
 
Posts: 1
Liked: never
Joined: Wed Apr 23, 2014 10:48 am
Full Name: Martin Dutsov

Re: Restore Sharepoint content

Veeam Logoby foggy » Tue Jul 12, 2016 12:53 pm

Martin, please contact technical support to get assistance with this.
foggy
Veeam Software
 
Posts: 14588
Liked: 1062 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Restore Sharepoint content

Veeam Logoby VanillaMastermind » Fri Aug 05, 2016 7:26 pm 1 person likes this post

I can confirm that the steps posted by smcauley (making a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\SPSToSQLMap\ and keying in the mappings there) worked in my environment as well. I no longer see the exclamation point with the error "SQL Server VM hosting the content database is missing". Thanks!
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: Restore Sharepoint content

Veeam Logoby tknaller » Tue Jun 20, 2017 12:40 pm

Tried the registry key aswell, but with no luck.

Could the cause be that SharePoint is backuped via VMware directly and SQL-Server via Veeam Agent for Windows?
tknaller
Novice
 
Posts: 9
Liked: 1 time
Joined: Thu Jun 01, 2017 9:00 am
Full Name: Thomas Knaller

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: jay.cheon and 20 guests