~ Chris Butcher | Senior Support Escalation Engineer

FIXHi folks, Chris Butcher here again with another DPM blog series for you. We get quite a few calls regarding SharePoint protection in System Center 2012 Data Protection Manager (DPM 2012) so I decided it was time to take a more in-depth look at this and go over some of the more common problems you may run into.

I decided to break this down into three parts, both to make it easier to digest and to keep the article from getting too long and hard to manage. The first part, which you’ll find below, will focus on issues you might encounter when configuring SharePoint Protection in Data Protection Manager. In this scenario we have no protection set up and we are going from ground zero. Part 2 will cover problems you may see when backing up SharePoint. This will be broken down into three areas: Backing up SharePoint Configuration and content databases from SQL, creating SharePoint metadata, and creating the SharePoint catalog. Lastly, part 3 will cover issues with restoring SharePoint with Data Protection Manager.

So with that out of the way, let’s go ahead and get started by taking a look at creating SharePoint protection in DPM 2012 and some points in the process where you might run into issues. This scenario assumes that DPM 2012 is installed, storage is provisioned and agents have been deployed, however we have no protection set up yet for SharePoint. 

Creating SharePoint Protection

1. To configure SharePoint protection, open the DPM management console, click Protection, then New to start the Create New Protection Group wizard. Click Next on the Welcome to the New Protection Group Wizard.

clip_image002

2. Select Servers and then click Next on the Select Protection Group Type page as shown here:

clip_image004

3. Expand the server that holds the SharePoint Web Front End (WFE) role. If you have more than one SharePoint WFE server, the one to select is the server where you previously ran ConfigureSharePoint.exe –enablesharepointprotection.

clip_image006

NOTE If you don’t see SharePoint as a protectable item under your WFE server, this usually indicates that you have not run configuresharepoint –enablesharepointprotection on the WFE server. You must run this from an administrative command prompt on the Web Front End server where you want to enable protection. This will enable the SharePoint writer to allow DPM to protect it.

When we expand the SharePoint server, this is what happens.

a. DPM queries VSS to see what data DPM can protect from that server.

b. If the SharePoint database is on a remote server, the DPM Server will connect to the SQL server that is hosting the SharePoint configuration database. For that to work, the DPM Agent needs to be installed on that server or servers. If that SQL Server is member of a cluster, all nodes of that cluster must have a DPM agent installed as well.

c. If all is fine up to this point, we should be able to expand the SharePoint data source and see the farm information details.

clip_image007

There are few things that could go wrong and cause you to not be able to see the SharePoint icon shown above, or if you do see it, you may get an error when trying to expand it. If you see either of these problems, here are some things to check:

1. If the SharePoint writer is disabled then there is no way for DPM to know that SharePoint is installed on that box. By Default, SharePoint VSS Writer is set to disabled and you must enable it by running the ConfigureSharePoint –EnableSharePointProtection command.

NOTE The SharePoint writer is named SharePoint 2010 VSS Writer in Microsoft SharePoint 2010.

2. Make sure that SharePoint VSS Writer is started and running.  

3. Make sure that the SQL Server VSS Writer on the SQL Server is started and running.

4. Make sure that the user account used for SharePoint VSS Writer has sufficient permissions on the SQL server.

5. Make sure the SQL server has the DPM agent installed. If it is not, you will probably get the error below, however the wizard will still allow you to continue.

clip_image010 Error text: DPM cannot protect your Windows SharePoint Services farm until you install agents on the following servers…

6. Make sure that the SharePoint databases are not being protected as SQL data sources.

7. Make sure that the SQL Server VSS Writer is running on the SQL server that holds the SharePoint databases.

It’s possible that you may also receive the error below after expanding the SharePoint icon and selecting the SharePoint farm for protection:

clip_image012

Error text: DPM cannot protect this SharePoint farm as it cannot detect the configuration of the dependent SQL databases. (ID: 32008)

If this happens, it could be that SharePoint is using a SQL alias and there is no alias configured in cliconfg or SQL Server Configuration Manager.

So now that we’ve broached the SQL alias, cliconfg and SQL Server Configuration Manager, let’s take a quick look at these.

CLICONFG.EXE (%windir%\system32) allows you to create a SQL alias for 64-bit clients. If your application uses 32-bit calls to access SQL, an alias defined with this tool won’t do any good.

CLICONFG.EXE (%windir%\SysWOW64) allows you to create a SQL alias for 32-bit clients. If your application uses 64-bit calls to access SQL, an alias defined with this tool won’t do any good.

NOTE If you are running a 32-bit operating system, %windir%\system32 will contain the 32-bit version of CLICONFG. The 64-bit of CLICONFG will not be available.

NOTE There is no 32-bit version of SharePoint 2010. All versions of Windows come with cliconfg.exe

Here is what CLICONFG.EXE looks like:

clip_image014

CLICONFIG and SQL Server Configuration Manager share the same information so if you have an alias configured in one location it will also show up in the other.

If you open SQL Server Configuration Manager you will see that there is a SQL Native Client ** Configuration (32bit) and a SQL Native Client ** Configuration. By expanding these, you can see that each has aliases and you can view and modify the aliases there.

In the view shown below you can see that the 32-bit aliases can be found by expanding the red box and that 64-bit aliases are found by expanding the blue box.

clip_image016

The biggest issue of note when dealing with aliases is to make sure that the version of SQL Client Connectivity components are the version that DPM requires. This is based on the version of SharePoint being protected and not the version of DPM. These tools must be installed on the WFE server where you are establishing protection and are installed by launching the SQL installation media and selecting this option. It will not affect any other settings.

SharePoint Version

SQL Client Connectivity Tools Required

2007

SQL 2005

2010

SQL 2008 (or SQL 2008 R2)

2013

SQL 2008 (or SQL 2008 R2)

Assuming there was no error selecting the SharePoint farm for protection, you can continue by setting up group information such as group name, retention rage, disk/tape backup etc. and complete the wizard.

That should cover the most common problems you’re likely to encounter when configuring SharePoint protection in Data Protection Manager. Next time we’ll take a look at some of the issues you might see when actually backing up SharePoint.

Chris Butcher | Senior Support Escalation Engineer | Microsoft GBS Management and Security Division
Wilson Souza | Senior Support Escalation Engineer | Microsoft GBS Management and Security Division

Get the latest System Center news on Facebook and Twitter:

clip_image001 clip_image002

System Center All Up: http://blogs.technet.com/b/systemcenter/

Configuration Manager Support Team blog: http://blogs.technet.com/configurationmgr/
Data Protection Manager Team blog: http://blogs.technet.com/dpm/
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
Virtual Machine Manager Team blog: http://blogs.technet.com/scvmm

Microsoft Intune: http://blogs.technet.com/b/microsoftintune/
WSUS Support Team blog: http://blogs.technet.com/sus/
The RMS blog: http://blogs.technet.com/b/rms/
App-V Team blog: http://blogs.technet.com/appv/
MED-V Team blog: http://blogs.technet.com/medv/
Server App-V Team blog: http://blogs.technet.com/b/serverappv
The Surface Team blog: http://blogs.technet.com/b/surface/
The Application Proxy blog: http://blogs.technet.com/b/applicationproxyblog/

The Forefront Endpoint Protection blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

DPM 2012 R2 SharePoint 2010 SharePoint 2012


The Official System Center Data Protection Manager Team Blog

{ Comments on this entry are closed }

Generating user message profiles for use with the Exchange Calculators

April 28, 2015

Greetings Exchange Community! My name is Dan Sheehan, and I work as a Premier Field Engineer for Microsoft, specializing in Microsoft Exchange. As a long time Exchange engineer I am an avid PowerShell scripter, and as such I end up writing a lot of PowerShell scripts. Today I present to you one of those scripts […]

Read the full article →

We put the Apple Watch in the hands of a mechanical watchmaker

April 27, 2015

This is a new challenge for Apple; can it turn a piece of technology into a massively desired fashion accessory? And can the Apple Watch stand up against its competition, from low-end quartz watches to high-end Rolexes? To answer these and many other questions, we put the Apple Watch in the hands of a mechanical […]

Read the full article →

Azure Premium Storage provides highest performance for SQL Server in Azure VM

April 27, 2015

Last week we announced the General Availability of Azure Premium Storage for Azure Virtual Machines. Premium Storage provides steady high throughput (up to 64,000 IOPs; 8x more than Standard Storage) at low latency (single-digit milliseconds; 8x less than Standard Storage). This enables enterprise SQL Server workloads (OLTP or Data warehousing) needing consistent high performance to run […]

Read the full article →

Shared VHDX Files – My Favorite New Feature in Windows Server 2012 R2

April 26, 2015

Hi Folks – In my last blog article on improvements to Failover Clustering and Hyper-V, I briefly covered the new shared virtual hard disk feature, which enables you to use a virtual hard disk file (VHXD file) as shared storage for a virtual machine failover cluster (also known as a guest cluster). This can help […]

Read the full article →

Commandments For The Speed Of Security

April 25, 2015

 PF Chang’s. Domino’s. eBay. Home Depot. Nieman Marcus. Sony. That isn’t just a list of wildly successful companies, it’s also a list of hacked companies; companies whose security was profoundly, publicly compromised. And it’s just a very small sample of a much larger set. The problem is not just that our industry’s approach to security […]

Read the full article →

Finally, a Progress Bar for DFSR Cloning

April 24, 2015

Heya folks, Ned here again. I came across a great post at Briantist.com today: a script to create a progress bar for DFSR Database Cloning. We never added a proper GUI for this operation and just relied on people reading the event log or waiting patiently – but Brian had other ideas: Get Progress on […]

Read the full article →

Deploy Azure RemoteApp collection to your Azure Virtual Network (with support for ExpressRoute)

April 24, 2015

We have listened to you and today I am pleased to announce a new feature based on your feedback. This feature gives you the ability to deploy hybrid Azure RemoteApp collections in your existing Azure Virtual Networks (VNET) rather than creating a separate Azure RemoteApp VNET. This also enables you to take advantage of the […]

Read the full article →

Comcast plans to drop Time Warner Cable deal

April 24, 2015

Comcast Corp. is planning to walk away from its proposed $ 45.2 billion takeover of Time Warner Cable Inc., people with knowledge of the matter said, after meeting with opposition from U.S. regulators. Comcast’s board will meet to finalize the decision on Thursday, and an announcement may come as soon as Friday, said one of […]

Read the full article →

Providing updates for Chrome for XP through 2015

April 23, 2015

On April 8, 2014, Microsoft stopped supporting Windows XP. This isn’t just a formality: computers running Windows XP haven’t received security patches in over a year and are facing a number of critical security vulnerabilities. At the operating system level, computers running XP are inherently in danger of being infected by malware and viruses, making […]

Read the full article →