SharePoint Explorer is unable to find content database

Availability for the Always-On Enterprise

SharePoint Explorer is unable to find content database

Veeam Logoby timmi2704 » Tue Mar 10, 2015 2:31 pm

Hi,

would someone be able to explain the requirements for Veeams SharePoint Explorer in order to make it able to automatically mount the content database belonging to a selected site collection?

When I select application file restore for SharePoint Items for the Web Server, Veeam automatically builds the SharePoint site collection list to select from.
But when I select the site collection, I get the error message "Unable to find SQL Server VM hosting the content database". Is there anything I missed?

If I use the SharePoint Explorer on an already mapped Database server, I can successfully mount the files and restore from it.

Thanks a lot for your ideas :-)
Timo
timmi2704
Enthusiast
 
Posts: 83
Liked: 3 times
Joined: Tue Jan 14, 2014 10:41 am
Full Name: Timo

Re: SharePoint Explorer is unable to find content database

Veeam Logoby foggy » Tue Mar 10, 2015 3:14 pm

Timo, do you have application-aware backup of the SQL server containing the content database for the selected collection? Do you see the exclamation mark on the corresponding collection's icon in the list?
foggy
Veeam Software
 
Posts: 14712
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SharePoint Explorer is unable to find content database

Veeam Logoby timmi2704 » Tue Mar 10, 2015 3:51 pm

Hi Alexander, thanks for your fast reply.

Yes, application-awareness is enabled for al SharePoint servers including the database server.
And you are right, I have the exclamation mark for all site collections in the list.
timmi2704
Enthusiast
 
Posts: 83
Liked: 3 times
Joined: Tue Jan 14, 2014 10:41 am
Full Name: Timo

Re: SharePoint Explorer is unable to find content database

Veeam Logoby foggy » Tue Mar 10, 2015 4:00 pm

Were there any VSS warnings in the corresponding backup job session? I mean, are you positive that the SQL server was successfully backed up and application-aware image processing didn't produce any warnings/errors? Exclamation mark means that Veeam B&R was not able to collect required information about SQL server during VSS backup.
foggy
Veeam Software
 
Posts: 14712
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SharePoint Explorer is unable to find content database

Veeam Logoby timmi2704 » Wed Mar 11, 2015 6:51 am

The last job runs were without any errors or warnings.
There are two different SharePoint farms in the job, could that be the issue?
For the second farm in the job, I have the same problem. But here some of the site collections do not show the exclamation mark.
Then there is an additional SharePoint-Test farm with a separate backup job with the same issue.
timmi2704
Enthusiast
 
Posts: 83
Liked: 3 times
Joined: Tue Jan 14, 2014 10:41 am
Full Name: Timo

Re: SharePoint Explorer is unable to find content database

Veeam Logoby Moebius » Wed Mar 11, 2015 10:01 am

I have exactly the same issue.
In my environment I have only one farm, but the SharePoint server and the SQL database are on two separate VMs.
No errors at all on the backup sessions, and yellow exclamation mark on all the corresponding collection's icons in the list. Application-aware processing is enabled.

A ticket is already open and currently being investigated; case #00822453.
Moebius
Veeam ProPartner
 
Posts: 139
Liked: 17 times
Joined: Tue Jun 09, 2009 2:48 pm
Location: Reggio Emilia, Italy
Full Name: Lucio Mazzi

Re: SharePoint Explorer is unable to find content database

Veeam Logoby foggy » Wed Mar 11, 2015 10:40 am 2 people like this post

Currently, application-aware logic uses NetBIOS names to locate corresponding SQL servers during backup and in some cases (where SQL server for the site collection is specified using IP address or SQL Server alias, for example), Veeam B&R still does not have the required information, even provided that application-aware backup was successful. If this is your case (I believe support will be able to verify that), you can configure SQL server mapping manually via registry, as far as I know, there's an ability to do that.
foggy
Veeam Software
 
Posts: 14712
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SharePoint Explorer is unable to find content database

Veeam Logoby Moebius » Wed Mar 11, 2015 1:49 pm 3 people like this post

Foggy, you're correct. Support sent me the registry mod to manually map the SharePoint servers to the relevant SQL vms.
The yellow exclamation marks disappeared and everything is working now. Good job Veeam!
Moebius
Veeam ProPartner
 
Posts: 139
Liked: 17 times
Joined: Tue Jun 09, 2009 2:48 pm
Location: Reggio Emilia, Italy
Full Name: Lucio Mazzi

Re: SharePoint Explorer is unable to find content database

Veeam Logoby chkiena » Thu Mar 12, 2015 1:05 pm

Hello, can someone please post the registry key, in our environment we have the same problem.
chkiena
Lurker
 
Posts: 1
Liked: never
Joined: Mon Oct 27, 2014 3:48 pm
Full Name: Christian Kienast

Re: SharePoint Explorer is unable to find content database

Veeam Logoby foggy » Thu Mar 12, 2015 1:55 pm

Christian, please contact technical support to get the key and instructions on how to populate/use it.
foggy
Veeam Software
 
Posts: 14712
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SharePoint Explorer is unable to find content database

Veeam Logoby mubasm » Mon Jun 08, 2015 12:00 pm

Dear Moebius, can you pls. share the registry key which you tried in sharepoint servers, as my SQL server is physical, will the registry key still work.
Support guy is telling as sql server is physical registry key will not work
mubasm
Lurker
 
Posts: 1
Liked: never
Joined: Sun Jun 07, 2015 8:37 am
Full Name: Mohammed Mubasheruddin

Re: SharePoint Explorer is unable to find content database

Veeam Logoby foggy » Tue Jun 09, 2015 1:21 pm

Mohammed, there's simply no sense in using them for physical servers, since physical servers cannot be backed up by Veeam B&R.
foggy
Veeam Software
 
Posts: 14712
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] SharePoint - Can't open SharePoint Explorer with SQ

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

I have 2 SharePoint 2013 servers, both running all the SharePoint services EXCEPT the database(s). Both of these servers point to separate SQL Server 2012 instances on another machine. The SharePoint APP servers are configured identically (I believe) with one exception. SPAPP1 used to point to a SQL instance somewhere else. We had to move those to this a new database server. The vendor that configured SharePoint said there were issues with migrating databases, so when databases got moved, he set up a SQL Server Alias (Can be found under SQL Server Configuration Manager -> SQL Native Client 11.0 Configuration -> Aliases).

OLD CONFIG
SPAPP1 -> DATABASE_SERVER_NEW\SP1
SPAPP2 -> DATABASE_SERVER_OLD\SP2

NEW CONFIG
SPAPP1 -> DATABASE_SERVER_NEW\SP1
SPAPP2 -> DATABASE_SERVER_OLD\SP2 (ALIASES TO DATABASE_SERVER_NEW\SP2)

I am able to open the SharePoint Explorer fine for SPAPP1 and can do item-level recovery. However, SPAPP2 won't let me open SharePoint Explorer. Instead, for each SharePoint site, I see an exclamation point with an error "SQL Server VM hosting the content database is missing". Is anyone else running into this issue when using a SQL Server alias? Or perhaps Veeam gets confused with multiple SQL Server instances on the same machine?
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: SharePoint Explorer is unable to find content database

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

Please contact support to get assistance in manual configuration of SQL server mapping (see above for details).
foggy
Veeam Software
 
Posts: 14712
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SharePoint Explorer is unable to find content database

Veeam Logoby jtroob » Fri Sep 23, 2016 8:37 pm

I contacted support and these are the registry settings you have to make to get this to working after using an sql alias:

(Copy/Paste from Veeam Support email)

Here is the info I was working off to create the Reg Key.

How-to:
Create HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\SPSToSQLMap\ key. It should be a sibling to the Veeam Backup and Replication key, not its child.
Add String values, where Name is the Sharepoint server FQDN (if FQDN doesn't work, try NetBIOS), and Data = "<SQL_SERVER>\<SQL_INSTANCE>".
E.g. Name = DHPSP1.domain.local (or e.g. DHPSP1), Data = DHPSPSQL1\SP2013. If using the default unnamed instance, Data would just be "DHPSPSQL1".
If you have multiple SQL servers for a single Sharepoint, separate instance names by ; e.g. DHPSPSQL1\SP2013;DHPSPSQL2\SP2013.
Add as many as needed if there are multiple Sharepoint servers.
Restart Veeam Backup Shell.
jtroob
Lurker
 
Posts: 1
Liked: never
Joined: Fri Sep 23, 2016 8:32 pm

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot], iostrikov, odruard, salyerma, Yahoo [Bot] and 54 guests