Virtual Learning Platforms Thread, Sharepoint and SQL backup in Technical; it's been very easy to back up SQL servers in the past I.E. full backup of mdb then incrementals of ...
22nd September 2009, 04:08 PM #1
Sharepoint and SQL backup
it's been very easy to back up SQL servers in the past I.E. full backup of mdb then incrementals of all the transaction logs however if a pupil is using sharepoint mysite documents and deletes a file how easy is it to get that file back? If a pupil has the mysite document area mapped as his or her My Documents area and deletes the file how does sharepoint track this?
22nd September 2009, 07:34 PM #2
There's various options.
There is of course the user's recycle bin if the document was deleted in the last 30 days, and then the site collection recycle bin for another 30 days after that. All accessed through the standard SharePoint UI.
If you have backups of the content database from when the document existed then you can restore it into a SharePoint environment (not your live one) and the access it, or there's various hacks you can use to get it directly out of the database
Notes from the Field : Recover Documents from MOSS 2007 Database
Michael O'Donovan's SharePoint and Stuff : How to recover SharePoint document once deleted from recycle bin
For all the above if the document is versioned you may need to try several backups to get the right version.
There will be some commercial tools which keep backups or help you retrieve documents from DB backups, but I haven't used any of them so can't comment on them.
Very best thing to do would be to try a test now and see what works for you. Don't leave it until you absolutely need to retrieve a document.
Thanks to rpwillis from:
wesleyw (23rd September 2009)
By stariq in forum Windows
Last Post: 29th October 2009, 04:49 PM
By DarkSithBob in forum MIS Systems
Last Post: 18th September 2009, 12:37 AM
By link470 in forum Windows
Last Post: 3rd September 2009, 08:23 PM
By mrforgetful in forum How do you do....it?
Last Post: 1st November 2007, 11:18 AM
By LordGrey in forum How do you do....it?
Last Post: 27th September 2006, 05:44 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)