Error Message

V-79-57344-33967 - The backup selection 'SharePoint - 80\Content-DB 1 (SQL2014\WSS_Content)' was not successfully processed for Granular Recovery Technology (GRT). The Database Recovery failed with Error 'UNKNOWN ERROR'. You will not be able to restore individual items for this backup selection

Completed status: Failed. Final error: 0xe00084af - The directory or file was not found, or could not be accessed. Final error category: Job Errors. For additional information regarding this error refer to link V-79-57344-3396

Causes

Currently there are two known causes; 

1) The data within the Sharepoint ContentDB is fragmented and prevents GRT processing completing successfully.

or 

2) If this issue is only occurring for Differential\incremental Backups, but Full Backups complete GRT processing correctly, another GRT backup of the SQL resources may be disrupting the Log Sequence Numbers (LSN), used in the chain of Differential\incremental backups. 

Solutions

1) The Sharepoint ContentDB can be Defragmented using the steps below.

• Open SQL Management Studio and connect to the Sharepoint SQL instance
• Right-click the ContentDB that fails the GRT processing and select 'New Query' from the menu
• Copy the script below into the query window (replacing with the name of the ContentDB that is failing GRT processing i.e. WSS_Content ) and then '! Execute' that

USE
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO

This will process against all tables in the database and may need to be run several times to defragment data to an optimal level. The time taken to complete this process is dependent on the size of the ContentDB and the amount of data referenced in that, but the processing time should reduce for each run, as the data is defragmented.

Repeat the above steps for any other ContentDBs that fail GRT.

2) Check for any other backup job (in Backup Exec or other 3rd party application) that takes GRT backups of the SQL resources used by the Sharepoint Farm, especially the ContentDBs. If any are found, disable GRT processing against that resource in the job or deselect the Sharepoint SQL resource completely from those Backup job. Then check whether Sharepoint Server Farm GRT processing now completes for both Full and Differential\Incremental original backups.