Solved

Sharepoint 2013 Backup Failure - BDC Service

Posted on 2013-12-03
11
1,064 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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
 
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

691 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