Solved

Sharepoint 2013 Backup Failure - BDC Service

Posted on 2013-12-03
11
978 Views
Last Modified: 2013-12-04
I have a single-server Sharepoint 2013 farm.  Whenever I attempt a Backup-SPFarm backup, I receive the following error message.  I've deleted and recreated my BDC service application with no success.  Please help.  When I venture to the spbackup.log file, I'm presented with the exact same error message.


FatalError: Backup failed for Object BDC_Service_DB_5ed98832-97a8-439c-892d-5814f802c7bb failed in event OnBackup. For m
ore information, see the spbackup.log or sprestore.log file located in the backup directory.
0
Comment
Question by:marrj
  • 6
  • 5
11 Comments
 
LVL 8

Expert Comment

by:vaderj
ID: 39693409
What happens when you attempt the backup through Central Administration?
0
 
LVL 1

Author Comment

by:marrj
ID: 39693677
I just ran a manual full backup from CA, and I get the exact same error.
0
 
LVL 8

Expert Comment

by:vaderj
ID: 39693691
What do the spbackup.log or sprestore.log files located in the backup directory say?
0
 
LVL 1

Author Comment

by:marrj
ID: 39693704
As I mentioned in my first post, they say this.

FatalError: Backup failed for Object BDC_Service_DB_5ed98832-97a8-439c-892d-5814f802c7bb failed in event OnBackup. For m
ore information, see the spbackup.log or sprestore.log file located in the backup directory.
0
 
LVL 8

Expert Comment

by:vaderj
ID: 39693723
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 1

Author Comment

by:marrj
ID: 39693848
I checked out the link.  None of my sites are locked.  I toggled the read-only switch and it didn't make any difference.  I also checked SQL to make sure all of my databases were "Normal".  They are.  For the record, my users can successfully read and write content to all site collections in the farm.  I just can't back it up.  The account I'm running the backup as is the admin/owner account and is a dbowner for all databases in SQL.
0
 
LVL 8

Expert Comment

by:vaderj
ID: 39693866
well it looks like it is failing on the BDC service application so that would not be one that users have access to, but if all the DB's look ok, then I guess thats all you can do.
I suppose if I were in your situation, I would just take a SQL DB backup at this point
0
 
LVL 1

Author Comment

by:marrj
ID: 39693968
So, if I have a good full backup of all SQL databases, is there any reason to mess with a Sharepoint Backup?  I've never quite understood the relationship between the two backup methods (SQL and SP).  I need to back up all content and configuration data.  If I was to need to restore to a point in time (let's say the server completely crashed), how would I go about doing so?
0
 
LVL 8

Expert Comment

by:vaderj
ID: 39694013
It would depend on your configuration.
Our own DR process that I just rewrote for our highly customized external facing web app involves a reinstall of OS, SharePoint, followed by installing our custom solutions, configuration changes, web.config changes and finally by attaching the content databases (which contain all the content).
We do not backup any configuration, or service application databases (with one exception - we do take backups of the Managed Metadata DB)

I believe MS recommends NOT backing up the configuration DB - attempting to attach to an existing config DB with new machines can cause a lot more trouble than its worth
0
 
LVL 1

Author Comment

by:marrj
ID: 39694076
I don't have any "custom" solutions in place that I would need to plan for in a DR scenario.  I just have a single standalone SP frontend and a single SQL backend.  Do you any recommendations for articles that would walk me through the best way to recover my farm?  I had honestly never heard of MS recommending to not backup the config database.
0
 
LVL 8

Accepted Solution

by:
vaderj earned 500 total points
ID: 39694097
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now