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 http://www.symantec.com/docs/TECH216595
Article Type
Technical Solution


Issue



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

 


Error



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

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


Environment



Microsoft Windows Small Business Server 2011

 


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.

 




Article URL http://www.symantec.com/docs/TECH216595


Terms of use for this information are found in Legal Notices