Solved

Sharepoint 2013 Backup Failure - BDC Service

Posted on 2013-12-03
11
1,024 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
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 walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 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