Solved

Sharepoint Backup and Restore individual files

Posted on 2016-08-08
4
96 Views
Last Modified: 2016-09-21
We have a Sharepoint 2013 installation with SQL on the same server (we are a small facility and only have 20-25 people that will access this install throughout the day). We have been running backups using our Unitrends backup appliance however recently I discovered after someone had deleted a PDF file on our content management system site that simply restoring an individual PDF file using the Unitrends appliance is not possible.

I am wondering if I should just resort to using the backup and restore that is built-in to Sharepoint to a location on our network and then have that backed up on our Unitrends appliance? or if there is a better way to be doing this. I know information is stored on the SQL server for Sharepoint but I don't understand how best to be able to recover something (besides using the built-in "Recycle Bin")
0
Comment
Question by:jb61264
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 17

Accepted Solution

by:
Walter Curtis earned 500 total points
ID: 41750517
There is really no good way to restore single items out of the box with SharePoint. You have a few options though, just not perfect ones...

Using the built-in SharePoint backup and restore, you schedule backups of sites and other objects. In order to restore a single item from one of those backups, you can restore the backed up site to a different location, and grab the item from there. The backups files can be backup using your unitrends appliance, but it does not add any functionality by doing that, it just makes sure you have a copy of the backup file.

You can also back up the SharePoint database(s). The restore would involve using the backup file created by SQL in a different SharePoint farm, or at least a different SharePoint web application. The commands would be somewhat different, but you can restore the data in the restore farm, and find the file you need to recover.

Important - If you try and restore in the same farm or web app, you have a high risk of overwriting the current production information, so restore activities should always occur in a different farm or web app, just a best practice.

Hope that helps...
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41753046
Any luck?
0
 

Author Comment

by:jb61264
ID: 41753972
SneekCo...thank you for the reply, just yesterday I was finally able to run the built-in Sharepoint backup. I was having issues running this to a new SAN network share I created for it and finally resolved that issue. I first ran a full farm backup and then separately ran a "site collection backup" of the three site collections we have.

1. We have a Project Web Access site
2. We have a basic intranet site
3. We have a content management site

So I have a full farm backup and also three site collection backups.

I haven't tried what you are suggesting and not completely sure I understand how to do it...are you saying I would create a new site collection and then restore my backup from the content management site to that new site collection to retrieve the file(s)?
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41808810
Thanks...

It is important to make sure that production data is not overwritten or lost during a restore procedure. So yes, one way to be careful is to create a site collection and restore that that new site collection, then navigate through the new collection to find the data you need. In another scenario you could actually restore to a different farm, a test farm for example, and get to the data that way.

Of course if you restore to a test farm, be very careful about and keep the data protected. If it is highly sensitive data, you don't want to restore to a location that everyone has access to.

Also, be very careful when restoring from a script or command line, if the source and destination values are switched or wrong, data could be lost or overwritten. Not that I have ever done that. :-)

Hope that helps...
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question