2012-05-24 04:19 AM - edited 2015-12-18 01:18 AM
I’m having an issue with the SMSP backup job I’ve configured for a customer. The SharePoint components are backing up okay, but it appears that indexing of the backed up data is failing. There is an SQL server error when the cloned database is presented to the SQL server as follows:
"[Microsoft][ODBC SQL Server Driver][SQL Server]Logical file 'WSS_Content_c553abc3-1f78-471e-a32e-d2082bdf8b49' is not part of database 'SMSP_B_WSS_Content_c553abc3-1f78-471e-a32e-d2082bdf8b49_sqlsnap__mssqlr2_05-24-2012_14.38.05'. Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, SevLevel 16, State 1, SQLState 42000"
I’ve attached the SMSQL clone backup log file which I think is most relevant, and the SMSP backup log file.
The customers SharePoint environment is as follows:
Any advice on how to remediate this issue would be most appreciated.
Professional Services, ASEAN
Solved! SEE THE SOLUTION
2012-05-30 04:24 AM
This is a known issue. Please check this Burt:
There is a workaround available:
1. Add the following registry key DWORD (32bit) value named "SupportLongDbName" under:
HKEY_LOCAL_MACHINE\SOFTWARE\Network Appliance\SnapManager for SQL Server\Server
Set its value to 0.
2. Restart SMSQL Service.
2012-05-30 09:24 AM
Thanks for your reply. Yes that is the issue I'm facing and it is with SMSP. It is worrying because I read in the BURT that backup database metadata will be overwritten where databases have the same first four characters in their database name, as is the case with the customer's Sharepoint databases evidently. I will get the customer to execute the workaround as soon as possible.
NetApp PSC, ASEAN
2012-08-15 09:58 PM
Thanks for your message. I did manage to fix this issue for the customer but I don't remember the exact process we followed. I think it is likely I executed the workaround discussed in the following BUG: http://support.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=585632
Basically, if you have two databases on a LUN which have the first few characters the same, SMSQL can incorrectly query the wrong database during a clone or restore operation.
I hope that helps.
NetApp PSC, ASEAN