Data Backup and Recovery

Problem with snapmanager for sharepoint 6

drutten57
14,004 Views

Help?

Plan: Daily

Job: FB20110213213858

Control Agent: hlmmoss02

Farm: Farm(HLMSQL09\MOSS:SHAREPOINT_CONFIG)

SharePoint Version: SharePoint 2007

Components: 63

Start Time: 2011-02-13 21:38:58

Finish Time: 2011-02-13 21:45:51

Exceptions: 6

Exception Details: Error During Backup Raw DB: Backup DB Error :SharePoint_Config

Error During Backup Raw DB: Backup DB Error :WSS_Content_80

Error During Backup Raw DB: Backup DB Error :SharePoint_AdminContent_3deb0028-d564-4417-b37f-c5ee53acd6c0

Error During Backup Raw DB: Backup DB Error :SharedServices1_DB

Error During Backup Raw DB: Backup DB Error :WSS_Content_SSP

Error During Backup Raw DB: Backup DB Error :SharedServices1_Search_DB

Statistical Result: 632 MB data, 0(0) site collections, 0(0) sites, 0(0) lists, 0(0) items.

---------

smsp,0.0 [agent version=6.0.0.0]

[fb20110213213858] [ntrolbackup00915]

error during backup raw db: backup db error :sharedservices1_search_db

[6.0.0.0]

---------------

smsp,0.0 [agent version=6.0.0.0]

[fb20110213213858] [pr_ntrolbackup00433]

backup node fullpath: farm(farm)\sharedservices1\shared search index ,exception: smmoss.common.apexception: error during backup raw db: backup db error :sharedservices1_search_db

at smmoss.vcspfarm.controlbackupworker.backuprawdbsupportgroup(backupnode node)

at smmoss.vcspfarm.controlbackupworker.backuposearchindex(backupnode node)

at smmoss.vcspfarm.controlbackupworker.startbackupnode(backupnode node) : error during backup raw db: backup db error :sharedservices1_search_db. at smmoss.vcspfarm.controlbackupworker.backuprawdbsupportgroup(backupnode node)

at smmoss.vcspfarm.controlbackupworker.backuposearchindex(backupnode node)

at smmoss.vcspfarm.controlbackupworker.startbackupnode(backupnode node)

[6.0.0.0]

47 REPLIES 47

michael9
4,176 Views

The "Raw DB: Backup DB Error" error indicates that SMSQL encountered an error while attempting to snapshot those SharePoint DBs.  On the SQL server that hosts those SharePoint DBs open up the SMSQL Management Console, go under reports > backups and find the backup job report that matches with the failed SMSP jobs; what does the detail of that backup report say?

EDWARD_SMITH
4,176 Views

Hi Michael,

I have been experiencing the same issue here, I have checked the relative SMSQL logs and they are running fine, all databases are backing up without any isuses and the snapshots are appearing on the volume as you would expect them to, yet the error is still appearing in the SMSP backup logs. Confused as I am getting conflicting reports!

Here is an example of the SMSP logs (these are from march but they still give the same error everyday)

Plan: Sharepoint  2010 Backups

Job: FB20140310190007

Control Agent: capweb002

Farm: Farm(CPLUKLONSQN0001:SHAREPOINT_BIDS_CONFIG)

SharePoint Version: SharePoint 2010

Components: 146

Start Time: 2014-03-10 19:00:07

Finish Time: 2014-03-10 19:15:10

Exceptions: 32

Exception Details: Error During Backup Raw DB: Wait For DB Group Backup Timeout, group instance: CPLUKLONSQN0001

StateService_ba968248d9e049bebe9067c5a2ecf188 exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup Timeout, group instance:

Application_Registry_Service_DB_628149f482f14bc2bf698c8094c247b6 exception

Secure_Store_Service_DB_b688df5854ec4747805dc5d0e4339ce5 exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup Timeout, group

Managed Metadata Service_074b7d358d244aa1bb2098316c2b86fa exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup Timeout, group

WebAnalyticsServiceApplication_StagingDB_c61b230d-2d29-4b73-9883-babb76eb4154 exception. (APException: Error During Backup Raw DB: Wait For DB Group

,

WebAnalyticsServiceApplication_ReportingDB_43c4019c-a49a-4761-90eb-2064c38aea35 exception. (APException: Error During Backup Raw DB: Wait For DB Group )

,

WordAutomationServices_7adf63799a9e42799bd0d1b4eef51eaa exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup Timeout, group

User Profile Service Application_ProfileDB_6e8b3606d645437baef8db452a04ca54 exception. (APException: Error During Backup Raw DB: Wait For DB Group

User Profile Service Application_SyncDB_5ff793b77b194de5bb55fbc0b8a59b40 exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup

Application_SocialDB_83dde0b702a44e068a7acf861508ccee exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup Timeout, group

Bdc_Service_DB_0f64723ee9774ec9bae5fb9a38baf2a2 exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup Timeout, group instance:

Search_Service_Application_DB_25ad565d30a7453fa7cebb05386854b8 exception. (APException: Error During Backup Raw DB: Wait For DB Group Backup Timeout,

Error During Backup FEW : Failed in reconnection

Statistical Result: 298 MB data, 1(0) site collections, 129(0) sites, 1339(0) lists, 102270(0) items.

michael9
4,176 Views

Hi Edward-

What are the exact versions of SMSQL and SMSP that you are using?   I've seen the "Error During Backup Raw DB" error even when the SMSQL backup report shows success due to a compatibility issue between certain versions of SMSP & SMSQL.

EDWARD_SMITH
4,176 Views

Hi Michael,

Thanks for your response.

We are using SMSP Version 6.0 and SMSQL 5.1. If it helps we are also running Snapdrive 6.3.1R1 on our VMs.

michael9
4,176 Views

I checked into it and the issue I was thinking of was for SMSP 6.0 with SMSQL 5.2 or greater (which is not a supported combination per the interop matrix.)  It shouldn't be an issue with SMSP 6.0 and SMSQL 5.1.

In any event all of versions you mentioned are quite dated; may want to consider updating to newer versions (staying at SMSP 6.x to keep it as an in-place upgrade.)  Be sure the validate the SMSP/SMSQL/SnapDrive combination in the IMT first - http://support.netapp.com/matrix.

COMITSUPPORT
4,176 Views

Our environment is SMSP 8, SMSQL 7, SnapDrive 7 and there are no problems

Public