Problem with snapmanager for sharepoint 6

[drutten57]

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]

[beaupre]

I suggest that you try excluding the sharedservices1_search_db database from the backup plan and try to take another backup.

If the backup is successful after excluding the sharedservices1_search_db database, then add the sharedservices1_search_db database back into the backup plan.

Ensure that the search crawl is paused/stopped for that SSP prior to kicking off another SMSP backup.

Thanks,
Mark

[drutten57]

I've excluded SharedServices1 and theres still a lot of failed parts..

Tried to backup the config only.. and it failed as well.

The crawl pauses as normal..

Path:Farm(Farm),Status:Skipped;
Path:Farm(Farm)\SharePoint_Config_HLMSQL09\MOSS,Status:Failed;
Error During Backup Raw DB: Backup DB Error :SharePoint_Config;
Path:Farm(Farm)\Windows SharePoint Services Web Application,Status:Successful;
Path:Farm(Farm)\Windows SharePoint Services Web Application\SharePoint - 80,Status:Successful;
Path:Farm(Farm)\Windows SharePoint Services Web Application\SharePoint - 80\WSS_Content_80_HLMSQL09\MOSS,Status:Failed;
Error During Backup Raw DB: Backup DB Error :WSS_Content_80;
Path:Farm(Farm)\WSS_Administration,Status:Successful;
Path:Farm(Farm)\WSS_Administration\Central Admin Web Application,Status:Successful;
Path:Farm(Farm)\WSS_Administration\Central Admin Web Application\SharePoint_AdminContent_3deb0028-d564-4417-b37f-c5ee53acd6c0_HLMSQL09\MOSS,Status:Failed;
Error During Backup Raw DB: Backup DB Error :SharePoint_AdminContent_3deb0028-d564-4417-b37f-c5ee53acd6c0;
Path:Farm(Farm)\Global Search Settings,Status:Successful;
Path:Farm(Farm)\Windows SharePoint Services Search,Status:Successful;
Path:Farm(Farm)\Windows SharePoint Services Search\Search instance_HLMMOSS02,Status:Successful;
Path:Farm(Farm)\Windows SharePoint Services Search\Search instance_HLMMOSS02\WSS_Search_HLMMOSS02_HLMSQL09\MOSS,Status:Skipped;
Path:Farm(Farm)\InfoPath,Status:Skipped;
Path:Farm(Farm)\InfoPath\FormService,Status:Successful;
Path:Farm(Farm)\InfoPath\InfoPathFormServices Manage Form Templates,Status:Skipped;
Path:Farm(Farm)\Windows SharePoint Solutions,Status:Skipped;
Path:Farm(Farm)\Front-End-Web Servers,Status:Skipped;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02,Status:Successful;
Path:Farm(Farm)\SharePoint_Config_HLMSQL09\MOSS,Status:Successful;
Path:Farm(Farm)\Windows SharePoint Services Web Application\SharePoint - 80\WSS_Content_80_HLMSQL09\MOSS,Status:Successful;
Path:Farm(Farm)\WSS_Administration\Central Admin Web Application\SharePoint_AdminContent_3deb0028-d564-4417-b37f-c5ee53acd6c0_HLMSQL09\MOSS,Status:Successful;
Path:Farm(Farm)\Windows SharePoint Services Search\Search instance_HLMMOSS02\WSS_Search_HLMMOSS02_HLMSQL09\MOSS,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISGlobal,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesWeb Application\SharePoint - 5002\2063513844,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesWeb Application\SharePoint - 5002\2063513844\C:\inetpub\wwwroot\wss\VirtualDirectories\5002,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesWeb Application\SharePoint - 80\1430458903,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesWeb Application\SharePoint - 80\1430458903\C:\inetpub\wwwroot\wss\VirtualDirectories\80,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesWeb Application\SharePoint Central Administration\253160142,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesWeb Application\SharePoint Central Administration\253160142\C:\inetpub\wwwroot\wss\VirtualDirectories\16962,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesDefault Site\1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesDefault Site\1\C:\inetpub\wwwroot,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesOther non-SharePoint sites\951338967,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\IISSettings\IISTemplatesOther non-SharePoint sites\951338967\C:\Program Files\Microsoft Office Servers\12.0\WebServices\Root,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\ADMISAPI,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\BIN,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\CONFIG,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\HCCab,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\Help,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\ISAPI,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\Resources,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\SharePoint Hive\TEMPLATE,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.XtraNavBar.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.XtraLayout.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.XtraGrid.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.XtraBars.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.XtraTreeList.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.XtraEditors.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\PresentationCFFRasterizer_3.0.0.0_31bf3856ad364e35,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.Utils.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.BonusSkins.v7.2_7.2.7.0_95fc6c5621878f0a,Status:Successful;
Path:Farm(Farm)\Front-End-Web Servers\HLMMOSS02\Global Assembly Cache\.NET Framework 2.0+\DevExpress.Data.v7.2_7.2.7.0_9b171c9fd64da1d1,Status:Successful;

[alliantenergynjk]

Hello,

Did you ever find a solution?  I am having the exact same error in my first attempt at a backup in SP 2010.

Thanks

Nelson

[drutten57]

No.. sorry.. But when i checked the logs.. all snaphosts are fine and all verifications..

[alliantenergynjk]

Yeah, same here.

I have been trying to get this working since December.  I am about ready to throw up the white flag and go with another product.  The level of complexity to get this working is amazing:  SnapDrive, SnapManager for SQL, SnapManager for SharePoint, System DBs and Users DBs have to be on different volumes, SnapInfo has to be on its own volume, different agents go on different machines...my head is spinning.

Nelson

[numbernine]

I'm not normally one to just moan, but we just spent weeks on the phone with Netapp support trying to get SMSP to work. Eventually we got it all sorted.

Now it's stopped working, obviously something has changed, but where to start..??

not looking forward to fixing this one.

[reena]

Hi,

Can you please share more details on what stopped working and what you think might have changed etc.?

Reena

[SFAIRLEY69]

My company is looking at getting Snapmanager. After reading all the problems, I might go with docave. Has anyone compared these two side by side.

[hutchinson]

Hi

I am having the exact issue with all the latest versions of each component, Snap Drive (6.4 x64), Snap Manager for SQL (5.2 x64) and Snap Manager for Sharepoint (6.1 x64). We are running MS Sharepoint 2010 on Windows 2008 R2. All SQL and Sharepoint volumes are presented over iSCSI and are RDM Luns.

Have any of you resolved this issue yet, I have been trying to get this SMSP config working 100% since September with assistance from NetApp!

Thanks

Andrew

[pratt]

Hi Andrew,

Do you have any logs, or events from the servers in the farm that you can share?  Also, have you confirmed the correct roles are assigned to the account being used on each database in SQL?

[hutchinson]

Hi Pratt

Yes all roles are assigned correctly based on recommendations from NetApp support.

See below:

* Backup Result Report *

Plan Name: Full Backup
Plan ID: PLAN20120206194220
Backup Level: Item Version Level
Backup Type: Full Backup
Job ID: FB20120207131702
Agent Host: S-HO-SP
Media Server: S-HO-SP
Agent Version: 6.1.0.0
Manager Version: 6.1.0.0
Username: bloor_homes\smsp
Start Time: 2012-02-07 13:17:02
End Time: 2012-02-07 13:29:08
Statistical Result: 2009 MB data, 0(0) site collections, 0(0) sites, 0(0) lists, 0(0) items.
Errors: Error During Backup Raw DB: Backup DB Error :SP2010_Config
Error During Backup Raw DB: Backup DB Error :SP2010_SharePoint_BloorHomes_Local
Error During Backup Raw DB: Backup DB Error :SP2010_AdminContent
Backup service database Bloor_Homes_Search_Service_Application_DB_1fe6be50a84342f9b7fb9ef796067411 exception. (APException: Error During Backup Raw DB: Backup DB Error :Bloor_Homes_Search_Service_Application_DB_1fe6be50a84342f9b7fb9ef796067411) , [ExceptionType:FromMemberAgentException]
Backup service database Bloor_Homes_Search_Service_Application_CrawlStoreDB_95d53f5ad5d143e19a8cb4b53468b153 exception. (APException: Error During Backup Raw DB: Backup DB Error :Bloor_Homes_Search_Service_Application_CrawlStoreDB_95d53f5ad5d143e19a8cb4b53468b153) , [ExceptionType:FromMemberAgentException]
Backup service database Bloor_Homes_Search_Service_Application_PropertyStoreDB_70a5aad30efe4c35978bde0c51d94bd7 exception. (APException: Error During Backup Raw DB: Backup DB Error :Bloor_Homes_Search_Service_Application_PropertyStoreDB_70a5aad30efe4c35978bde0c51d94bd7) , [ExceptionType:FromMemberAgentException]

[pratt]

Hello Andrew,

Thanks for the info.  I have seen this type of issue before, and what I think could be happening is a "character limit issue".  As you see when SharePoint creates the database it adds a GUID to the name of the database which makes the DB name lenghty.  In the past there was a limitation for DB name from 70-80 characters, and a path of up to 260 characters. If this character limit is passed, it will result in failed backups.

What I see in the field is, the DB names are modified (Shortened), or created prior with shortend names, or even shortend paths (i.e. volume/qtree/lun/db name). There are resources on the net that speak to shortening the SharePoint DB names.

Now, I am not sure this is your issue, but based on the logs you posted, thats what stood out.  I will say, I had a custormer with this exact issue, and shortening the name resolved the issue.  Hope this helps.

[hutchinson]

Thank you for your prompt response Pratt, I will investigate this today.

[hutchinson]

I just ran a backup of one component at that also failed, the name is within that character limit though:

Path:Farm(Farm)\SP2010_Config_S-HO-SPDB01,Status:Failed;
Error During Backup Raw DB: Backup DB Error :SP2010_Config
Path:Farm(Farm)\WSS_Administration\SharePoint Central Administration v4\SP2010_AdminContent_S-HO-SPDB01,Status:Failed;
Error During Backup Raw DB: Backup DB Error :SP2010_AdminContent

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

[pratt]

Thanks for the update Andrew.

Quick question - does this database reside on the same LUN or in the same Volume as those with the longer DB names?