Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sharepoint Backup and Restore individual files

Posted on 2016-08-08
4
Medium Priority
?
132 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
  • 3
4 Comments
 
LVL 20

Accepted Solution

by:
Walter Curtis earned 2000 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 20

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 20

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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

876 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