Sharepoint GRT backup fails with error 'The backup selection was not successfully processed for Granular Recovery Technology (GRT)'
Error Message
V-79-57344-33967 – The backup selection 'SharePoint – 80Content-DB 1 (SQL2014WSS_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
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 <ContentDB> with the name of the ContentDB that is failing GRT processing i.e. WSS_Content ) and then '! Execute' that
USE <ContentDB>
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO