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