cdarbonne
asked on
Potential backup solution
Hi, I have an environment where I have users enter data into a custom list in Sharepoint 2010. I collect their data into an Access 2010 database and have a union query that merges it for me.
Recently, one of the users (accidentally?) deleted the site. Our IT department's backup plan isn't enough that we're happy with the recovery period or the last saved date.
So, we'd like a way to backup only the custom lists on the site.
I thought of the following scenarios and wondered if others could give their opinion.
1. Create a copy of the list in addition to the linked list in the Access Database (haven't tried this yet)
2. Export each datasheet as an excel file and store those locally.
I understand that a packaged backup of the site itself isn't possible given the nature of sharepoint so I'm trying to find a potential solution. Any help is appreciated!!
Thank you
Recently, one of the users (accidentally?) deleted the site. Our IT department's backup plan isn't enough that we're happy with the recovery period or the last saved date.
So, we'd like a way to backup only the custom lists on the site.
I thought of the following scenarios and wondered if others could give their opinion.
1. Create a copy of the list in addition to the linked list in the Access Database (haven't tried this yet)
2. Export each datasheet as an excel file and store those locally.
I understand that a packaged backup of the site itself isn't possible given the nature of sharepoint so I'm trying to find a potential solution. Any help is appreciated!!
Thank you
ASKER
Yikes. can you tell me what PK/FK stands for?
This is a large corporation and everyone is my boss ;) we'll see how it goes. I do appreciate the info though.
This is a large corporation and everyone is my boss ;) we'll see how it goes. I do appreciate the info though.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much
Appreciate the points, but if I were you, I probably would have left this open for a while longer to get some ideas from other Access / Sharepoint experts. This is a critical issue and like surgurey, I would attempt to get as many opinions on the topic as I could.
If you want to reopen the question, click the request assistance hyperlink in the original post and request that a moderator reopen the question.
If you want to reopen the question, click the request assistance hyperlink in the original post and request that a moderator reopen the question.
ASKER
oh ok....i'll do that. thanks.
Hopefully, you were able to convince your boss that they (the IT department) needs to be backing up your lists on a more frequent basis.
The problem with any simple (Access, Excel, ...) external backup solution is that even if you have all the data, when you attempt to put it back into your SharePoint list, you cannot insert a record with an ID (Sharepoint PK) that has already existed. So any of your PK/FK relationships will be invalid.
If this is a critical application, you should make the case to your boss or whoever controls the SharePoint backup policy to ensure that those lists that are critical get backed up on a frequency that is acceptable to your operation. You management needs to understand the risks associated with infrequent backups.