+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,211
    Thank Post
    226
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    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?


    Wes

  2. #2
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    182
    Thank Post
    50
    Thanked 63 Times in 51 Posts
    Rep Power
    26
    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.

    Richard

  3. Thanks to rpwillis from:

    wesleyw (23rd September 2009)

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 17
    Last Post: 29th October 2009, 04:49 PM
  2. backup of SIMS,FMS SQL & Docstorage
    By DarkSithBob in forum MIS Systems
    Replies: 2
    Last Post: 18th September 2009, 12:37 AM
  3. Replies: 9
    Last Post: 3rd September 2009, 08:23 PM
  4. Backup SQL 2005 with BackupAssist - Eror Messages grr
    By mrforgetful in forum How do you do....it?
    Replies: 2
    Last Post: 1st November 2007, 11:18 AM
  5. ...Install MS SQL 2005 and Veritas Backup Exec??
    By LordGrey in forum How do you do....it?
    Replies: 3
    Last Post: 27th September 2006, 05:44 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •