Backup Troubleshooting - SharePoint Server iDataAgent
SP0001: Backup process hangs in pending state
The backup processes may hang in pending state if the permissions described in the Verify Required Permissions section are not set correctly set at the service account level.
SnapProtect Services account might not have correct permissions set. However, you can run the following script on the client machine that has the SharePoint agent installed on it to check and assign permissions:
- Ensure that you have full administrator privileges.
- Start the Command Prompt and navigate to the C:\Program Files\##_DOC_OEM_INSTALL_DESTINATION_COMPANY_FOLDER_##\SnapProtect\Base.
- For SharePoint 2007, run CVSPCompatibilityCheck2007.exe
For SharePoint 2010, run CVSPCompatibilityCheck.exe
For SharePoint 2013, run CVSPCompatibilityCheck2013.exe
C:\Program Files\##_DOC_OEM_INSTALL_DESTINATION_COMPANY_FOLDER_##\SnapProtect\Base> <Compatibility Check.exe> -vm <Instance number> -check
C:\Program Files\##_DOC_OEM_INSTALL_DESTINATION_COMPANY_FOLDER_##\SnapProtect\Base> <Compatibility Check.exe> -vm <Instance number> -assign
Use -db parameter if you are running the CVSPCompatibilityCheck tool only for the SharePoint Farm backup set.
C:\Program Files\##_DOC_OEM_INSTALL_DESTINATION_COMPANY_FOLDER_##\SnapProtect\Base> <Compatibility Check.exe> -vm <Instance number> -check -db
C:\Program Files\##_DOC_OEM_INSTALL_DESTINATION_COMPANY_FOLDER_##\SnapProtect\Base> <Compatibility Check.exe> -vm <Instance number> -assign -db
Ensure to meet the following prerequisites before running the CVSPCompatibilityCheck tool.
- SnapProtect services account must be a member of the local administrators group.
- Log in to the SharePoint server as a SnapProtect service account user to run this tool.
- Verify that SQL Server Agent and the SQL server services are running under the same account. It doesn’t have to be the same as SnapProtect services account.
- SnapProtect services account should at least be a public user on the SQL server where the configuration database resides.
- Restart the SnapProtect services to update service account information after assigning permissions, else it will use old information in the cache.
- The verification report will be displayed in the following format:
Parameter Description of Parameter Values -vm Lists the instance number. In case, this is not specified the system will prompt for instance number. -check Checks for the required permissions. -assign Checks and assigns the missing permissions. -db Checks and assigns the missing permissions for the SharePoint Farm backup set. Use this parameter if you are running the CVSPCompatibilityCheck tool only for the SharePoint Farm backup set.
SP0002: Library Backup Failures
If a backslash ('\') character is present in a List item name, it cannot be backed up. To successfully back up the List item, it is recommended to rename the item without the backslash.
SP0003: "SQL Chain Error" message displayed while running a transaction log backup
This may occur when SQL Server iDataAgent is configured to back up all SharePoint Databases. However, the SharePoint Server iDataAgent also backups up the Service Applications databases for SharePoint. Therefore the SQL Server iDataAgent Transaction Log backups may fail with SQL Chain error message.
If SharePoint Services Applications are backed up using SharePoint Server iDataAgent then the corresponding Service Application databases should be excluded from SQL Server backup.
SP0004: Error message: "Exception of type 'Cobalt.ErrorException' "
This error occurs due to the creation of SQL database snapshot during the first SharePoint 2013 document backup.
To resolve this, disable bUseSQLSnapshot before running the first document backup. After running the first document backup, enable bUseSQLSnapshot for all subsequent backups.
- Disable bUseSQLSnapshot by changing its value to 0.
- From the CommCell Browser, navigate to Client Computers.
- Right-click the <Client> and then click Properties.
- On the Client Computer Properties dialog box, click Advanced.
- Click the Additional Settings tab.
- Click Add.
- In the Name box, type bUseSQLSnapshot.
- The Category and Type details will be automatically populated.
- Alternatively, you can click Lookup and search for the additional setting using the Find box.
- In the Value field, enter 0.
- Click OK.
- Run the first SharePoint 2013 document backup.
- Enable bUseSQLSnapshot by changing its value to 1.
SP0008: SharePoint database level backup operation completes with errors
SharePoint database level backup operation completes with multiple failed items, mostly shared services and service applications.
Error Code 28:298
The backup job failed. For more information, see the error log that is located in the backup directory.
SharePoint database level backups use Microsoft APIs to invoke backup commands. These commands are set up to run from the software created temporary UNC paths out of the Job Results directory. These UNC paths are created with the NTFS permissions that exist already in the file structure. The APIs when called, impersonate the user accounts that the particular SharePoint service is running under. These accounts do not have any permission on the file structure of that SharePoint server.
On the SharePoint server where the SharePoint agent is installed, grant the local user group with the read/write NTFS permissions on the JobResults directory path.
SP0010: SharePoint backup operation may fail if a virus scanner is running on the server
Backup operation fails if a virus scanner is running on the SharePoint server. You might see the following error in the CVSPBackup.log file.
The specified network name is no longer available.
During a backup operation, a virus scanner running on the SharePoint server may delete staging files or network share.
On the SharePoint server, either disable the virus scanner or exclude SnapProtect processes from the virus scanner configuration.
SP0014: SharePoint document backup fails with error: "The file you are attempting to save or retrieve has been blocked from this Web site by the service administrators"
Backup operation fails with the following error message:
The file you are attempting to save or retrieve has been blocked from this Web site by the service administrators.
This error occurs because SharePoint has marked a file extension as blocked. If you have uploaded a file with this file extension (prior to marking the file extension as blocked), then the backup of that file will fail.
Set error rules to ignore these errors during a backup operation. For more information on creating error decision rules, see Customizing Completed with Errors Condition.
Alternatively, you can also remove the file extension from blocked file types in the Central Administration page.