Sharepoint GRT backups fail with 'Access Denied' error when the Content Database has multiple SQL Data files.

Article:TECH153731  |  Created: 2011-02-18  |  Updated: 2014-09-25  |  Article URL http://www.symantec.com/docs/TECH153731
Article Type
Technical Solution


Issue



If an SQL database is created with multiple Data files (.MDF and .NDF files), then referenced as a Content Database in Sharepoint, Granular Restore Technology (GRT) backups of that database to disk may fail with an '0xe0001602 - Access Denied' error and some or all of the GRT selections will be missing for that database.  In some rare cases the backup may be successful but expanding the content database in restore selections will be missing some or all GRT selections.  Backups to tape will have all GRT selections displayed but some or all GRT items will not be restorable.  Non-GRT backups to tape or disk are not impacted by this issue and are fully restorable.


Solution



This issue is resolved in Hotfix TECH164658 for Backup Exec 2010 R2.  This issue is also resolved in the initial Backup Exec 2010 R3 release.  Backup Exec 2010 users must upgrade to Backup Exec 2010 R2 with the referenced hotfix or Backup Exec 2010 R3 to resolve this issue.

Supplemental Materials

SourceETrack
Value2130044
Description

GRT backup does not capture additional SQL data files or filegroups for content database.





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


Terms of use for this information are found in Legal Notices