Restoring individual SharePoint 2003 items (Microsoft SQL Server-based) from full database backups

You can restore individual documents, images, and list items from full SharePoint database backup jobs if you selected the following option during the backup job:

Use Backup Exec Granular Recovery Technology (GRT) to enable the restore of individual documents from the database backup (available for full backups only).

See How to restore individual items by using Granular Recovery Technology.

The option to enable the restore of individual documents is not available for differential backup jobs.

To restore individual documents from full database backups

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. Navigate to the backup set for the appropriate content database, and then select the documents or images that you want to restore.

  4. On the Properties pane, under Settings, click Microsoft SharePoint.

  5. Do one of the following:

    If versioning is enabled on the device to which you are restoring individual documents

    Select one of the following options:

    • Add as a new version

      Backup Exec restores the existing item as a new version, making it the most recent version of the existing item.

    • Skip if the item exists

      Backup Exec does not restore the item if an identical item exists in the restore destination. Backup Exec notes that the file was skipped in the job log.

    • Restore over existing items

      Backup Exec replaces the existing item with the restored item.

    If versioning is not enabled on the device to which you are restoring individual documents

    Select one of the following options:

    • Skip if the item exists

      Backup Exec does not restore the item if an identical item exists in the restore destination. Backup Exec notes that the file was skipped in the job log.

    • Restore over existing items

      Backup Exec replaces the existing item with the restored item.

  6. Select the Restore only the most recent version of an item check box if you only want to restore the most recent version of each document you restore.

  7. Check the Include security information option to restore any applicable security information with the item.

    You can restore different levels of security based on the SharePoint item you restore:

    • Sites - User and SharePoint Group information and security ACL are restored for top-level sites

    • Sub-sites - Security ACL is restored

    • Lists - Security ACL and other security-related information is restored

  8. If you are restoring from tape, do the following steps in the order listed:

    • On the Properties pane, under Settings, select Advanced.

    • Specify the path for a temporary staging location in the option titled Path on an NTFS volume that is local to the media server for temporary storage of restore data.

      The path must reside on the Backup Exec media server. Symantec recommends that you avoid using system volumes for temporary staging locations.

  9. Set additional restore options on the Properties pane, or start the restore job.