The granular restore of a Sharepoint file or doc fails with 'An error occurred on a query to filegroup'

Article:TECH169440  |  Created: 2011-09-13  |  Updated: 2013-07-25  |  Article URL http://www.symantec.com/docs/TECH169440
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



The restore of a document or file from a GRT enabled Sharepoint agent backup fails with the error, 'An error occurred on a query to filegroup'.


Error



V-79-57344-33938 - An error occurred on a query to filegroup ContentDBName\/\SiteName\Shared Documents\Drafts..DocumentName.docx.
WARNING: The file DocumentName.docx was restored from a file that was corrupt when it was backed up, or the backup file is now missing or corrupt. Try restoring the file from another backup, or try repairing the file.


Cause



The media server beremote debug will show that the document cannot be found in the content database image for restore:

[5148] 09/08/11 12:00:46 [ndmp\loops]         - LP_ENV::MsgError: error 0xe0008492 processing object ContentDBName\/\SiteName\Shared Documents\Drafts\DocumentName.docx

 


Solution



A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.

Backup Exec 2010 Rev 5204 Service Pack 3 (TECH203157)

Backup Exec 2012 Rev 1798 Service Pack 2 (TECH203155)

 

Workaround:

The content database containing the document or file needed for restore can be redirected to an alternate Web Application in a different Sharepoint farm or can be redirected to an alternate SQL server and connected to an alternate Web Application in the production farm.  Once the database is connected to another Web Application, the desired granular content can be extracted.

NOTE:  When the Sharepoint content database displaying this issue resides in SQL 2000, the issue may be resolved with an upgrade to SQL 2005 or later.  A new backup will need to be performed of the database in order for GRT restores to complete successfully.


Supplemental Materials

SourceETrack
Value2536526
Description

SPSV3: GRT restore fails with 'An error occurred on a query to filegroup...'


SourceUMI
ValueV-79-57344-33938
Description

An error occurred on a query to filegroup ContentDBName\/\SiteName\Shared Documents\




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


Terms of use for this information are found in Legal Notices