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

Problem

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 Message

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.

 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)