?
Solved

Sharepoint 2013 Backup Failure - BDC Service

Posted on 2013-12-03
11
Medium Priority
?
1,132 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 9

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 9

Expert Comment

by:vaderj
ID: 39693691
What do the spbackup.log or sprestore.log files located in the backup directory say?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 9

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 9

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 9

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 9

Accepted Solution

by:
vaderj earned 2000 total points
ID: 39694097
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

862 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