Backup Troubleshooting - SharePoint Server iDataAgent

SP0001: Backup process hangs in pending state

Cause

The backup processes may hang in pending state if the permissions described in the Prerequisites section are not set correctly set at the service account level.

Resolution

Manual creation of service account may lead to incorrect permission settings. However, you can run the following script on the client machine that has the SharePoint agent installed on it to check and assign permissions:

1. Ensure that you have full administrator privileges.
2. Start the Command Prompt and navigate to the C:\Program Files\##_DOC_OEM_INSTALL_DESTINATION_COMPANY_FOLDER_##\SnapProtect\Base.
3. 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 the -db parameter if you are running the CVSPCompatibilityCheck tool only for the SharePoint Farm BackupSet.

   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 obtain the permissions described in the Prerequisites section before running the CVSPCompatibilityCheck tool.

4. 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 BackupSet. Use this parameter if you are running the CVSPCompatibilityCheck tool only for the SharePoint Farm BackupSet.

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

Cause

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.

Resolution

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' "

Cause

This error occurs due to the creation of SQL database snapshot during the first SharePoint 2013 document backup.

Resolution

To resolve this, disable bUseSQLSnapshot before running the first document backup. After running the first document backup, enable bUseSQLSnapshot for all subsequent backups.

1. Disable bUseSQLSnapshot by changing its value to 0.
   1. From the CommCell Browser, navigate to Client Computers.
   2. Right-click the <Client> and then click Properties.
   3. On the Client Computer Properties dialog box, click Advanced.
   4. Click the Additional Settings tab.
   5. Click Add.
   6. In the Name box, type bUseSQLSnapshot.
   7. The Category and Type details will be automatically populated.
   8. Alternatively, you can click Lookup and search for the additional setting using the Find box.
   9. In the Value field, enter 0.
   10. Click OK.
   11. Restart the services on the client computer.
2. Run the first SharePoint 2013 document backup.
3. Enable bUseSQLSnapshot by changing its value to 1.

SP0008: SharePoint database level backup operation completes with errors

Symptom

SharePoint database level backup operation completes with multiple failed items, mostly shared services and service applications.

Cause

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 JobResults 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.

Resolution

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

Symptom

Backup operation fails if a virus scanner is running on the SharePoint server. You might see the following error in the CVSPBackup.log file.

Cause

During a backup operation, a virus scanner running on the Sharepoint server may delete staging files or network share.

Resolution

On the SharePoint server, either disable the virus scanner or exclude SnapProtect processes from the virus scanner configuration.