Backup of SBS 2011 SharePoint Databases fail with An error occurred on a database query

Problem

Backup of SMSMONITORING, SHAREPOINT, MICROSOFT##SSEE Databases fail with the following errors:

 

Error Message

V-79-57344-33938 - An error occurred on a database query.

V-79-57344-33932 - Unable to attach to a resource.

Cause

The default settings on Microsoft Windows Small Business Server 2011 only activate Shared Memory as an enabled protocol for contacting them.

 

Solution

Enable the additional protocols Named Pipes and TCP/IP per the following steps:

1. Navigate to the Start Menu Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Configuration Manager.

2. Expand SQL Server Network Configuration,

3. Select each of the databases, right-click and select Enable for each of Named Pipes and TCP/IP. 

Note:  The Recovery model for ShareWebDb may also need to be changed from Full to Simple.

 


Applies To

Microsoft Windows Small Business Server 2011

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)