0

i want to restore only items in the specific list from my backups .bak file with 14 Gigabytes.(i have content database full backups that every day made automatically. )

cmp solution backup and restore lists one by one .

or only restore one item in a list that deleted from recycle bin. (which way to find which user deleted that item and when?)

this list has lookup field that all of my other lists used it .if this is not possible so i should seeking for solution to re-creating that item with that original id

i download and install red-gate compare tools that it cant read version 12 SQL server database of backups.

i cant restore completely my last backups cause other lists had many changes by users.

3 Answers 3

1

If you have a database backup, you can use the 'Recover data from an unattached content database' functionality to recover only a single list and then re-import that data into SharePoint.

To do this, you'll have to restore the database, either to another instance of SQL that you can then access via SharePoint (recommended), or to the same instance but as a different database name/file name. Note that you need to be careful during this step if using the same instance that you don't overwrite the database that is currently in use. Taking a backup of the current production database before you start is important. If possible use another SQL instance, or even a test/development instance if you can as there is then no way you can impact the production farm.

Once the database backup is restored to SQL and the appropriate accounts have been added (if required) to allow SharePoint to access the content database, the following steps can be used to recover information:

  1. Navigate to 'Backup and Restore' in Central Admin
  2. Select 'Recover data from an unattached content database'
  3. Ensure that the database server to be used is correct, and modify if required.
  4. Enter the database name, and optionally authentication information if required.
  5. Select the operation to perform, initially browse content. Database server, DB name, authentication and operation screen
  6. Drill down through the site/lists and libraries until you have found the one that you're interested in and then select 'export site or list' from the available options. This generates a SharePoint backup file containing the list information. Site collection, site and list selection - keep drilling down until you reach the level from which you want to extract information
  7. Restore the list backup using the PowerShell Import-SPWeb command (yes, seems strange, I know, but that's the command to use against the file produced), preferably to a new location so that you can then decide which information to copy back into the list that you were working with.
8
  • 1
    This will restore the whole list, not a single item, right?
    – Nils
    Oct 11, 2016 at 15:48
  • 1
    Yes, which is why I suggest restoring it to a new location (create a new sub-site for the purpose perhaps) so that you can then extract just a few items should you need to do so. Oct 11, 2016 at 15:52
  • If you want to recover just a single item, you'll want to look at one of the third-party tools to help you. Oct 11, 2016 at 15:52
  • 1
    Can I just double-check that we're talking about SQL backups here? If this is the case, you should be able to restore a backup either to the same instance (as either the same database name, or a different database name), or to a different instance. If you can't, then you have a problem! Oct 14, 2016 at 9:11
  • 1
    To import the .cmp file contents once that has been generated by the unattached database operations described above, use the following command: Import-SPWeb sharepoint.domain.com/sitecol/web -Path "C:\MyFileLocation\MyBackupFile.cmp" - obviously you'll need to replace the URL with that of the sub-site that you wish to import the list into and the location and filename with the correct ones for your .cmp file. There are other options for Import-SPWeb that can be found at technet.microsoft.com/en-us/library/ff607613.aspx. Oct 14, 2016 at 9:15
1

Sharepoint native backup or content db restore does not provide item level recovery.

  • if you have any test farm, then you restore the database there and from their move the item to your production
  • if you have any 3rd party recovery tools then you can restore item
2
0

Here is a list of Backup and Recovery Tools for SharePoint.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.