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


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.


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



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.



Did this article answer your question or resolve your issue?


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


How can we make this article more helpful?

Email Address (Optional)