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

Article:TECH216595  |  Created: 2014-04-10  |  Updated: 2014-07-09  |  Article URL
Article Type
Technical Solution


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



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

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


Microsoft Windows Small Business Server 2011



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.


Article URL

Terms of use for this information are found in Legal Notices