How New Features of SharePoint 2010 Change Your Backup and Recovery Strategy. Kieron Darley Kieron.Darley@Quest.com. Me. Kieron Darley, Solutions Architect, Quest Software Based in Melbourne( ish )…. Agenda. SharePoint 2010: what’s new for backup and recovery Central Administration
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
SharePoint 2010: what’s new for backup and recovery
Find the backup file that contains that document you need. You’ll need to know document original location so that you can match that to the content database. You will also need to find out when the document was corrupted or deleted, so that you grab the backup file from the right date. When you have all this information you can find the required backup file (or probably request it from your SQL DBA or Backup operators).
Just having the backup file is not enough, to use the unattached content database recovery you need the database mounted on a SQL server. This can be the same SQL instance used by SharePoint, or a different SQL box. If you restore into the same SQL instance make sure you (or your SQL DBA’s) use a different name for the restored database and don’t override the production content! Note the name of the SQL Server instance and the name of the database copy.
Navigate to Backup and Restore and click the “Recover data from an unattached content database” link under Granular Backup.
Specify what you want to do. Note that none of the available options actually allows you to restore a document, you can either create a backup of site collection or export a site or list. If you only need a single document, you’ll need to export the library in order to get it.
You can also specify the name for the export file and the export options, such as whether security and versions should be included in the export. You are ready to start the export.
You have now completed the Unattached Content Database Recovery…
Wait, did you actually need that document? All you have is the export.cmp file, where to look next?
There is no import available in the Central Administration UI. So what do you do next?
Which is PowerShell with the Microsoft.SharePoint.PowerShellsnap-in already loaded. Then use the Import-SPWebcmdlet to import the library. It is important to understand you cannot restore a list or library under a different name. If a document library with the same name already exists in the destination site, the import will merge contents and by default create new document versions where possible.
Once this is done, you can safely delete the imported document library from SharePoint, and delete the temporary database from SQL server.
You can review the log file that gets created and you will see any restored list items and attachments.