Solved

Backing up Data in a Hybrid Access Database with Sharepoint Data

Posted on 2013-06-12
4
301 Views
Last Modified: 2013-06-16
I am deploying an Access database with the data on SharePoint.  I need to be able to backup the SharePoint data and restore it if necessary without using the backups created by the SharePoint administrators.  How can I create backups of my SharePoint data?
0
Comment
Question by:mkwest
[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
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:vaderj
ID: 39242302
Is your Access database a regular access database or is it an Access Web Database?
If its a regular access database, just copy the file via explorer view to where ever you would like to back it up - you can setup a windows scheduled task to do this even.
If it is a Web Database, things get a little trickier - Everything in SharePoint is a .net object which means that it is no longer just a file - it has properties, methods, references, etc that regular files do not have.  It is not impossible to export a web database, or any SharePoint object for that matter, into a file - its the process called serialization. SharePoint 2010 has a PowerShell command just for that which is Export-SPWeb however you do need PowerShell (SPShellAdmin) access on one of the SharePoint servers to use this command.
Why cant you use the backups that your admins use?
0
 

Author Comment

by:mkwest
ID: 39242331
Its a web database.  I need to create a backup at a specific point in the process, not a scheduled backup, for example each night.  What options do I have that don't require sharepoint administrator rights?
0
 
LVL 8

Accepted Solution

by:
vaderj earned 500 total points
ID: 39242360
as far as I am aware, this is not possible - you are wanting to perform an administrative task, you will need administrative privileges.  Why can you not get assistance from your SP Admins? If you can tell them what you are trying to accomplish and why, I cant see how they would not be willing to help. I am a SP admin myself and happily assist my users in tasks like this all the time
0
 

Author Closing Comment

by:mkwest
ID: 39252164
My SP Admins are not responsive to my needs to backup/restore my data so this solution is not very helpful, but if it is not possible for me to copy my own data off of sharepoint to store elsewhere then it is what it is.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

617 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