Thursday, March 13, 2014

How to recover SharePoint 2013 access apps record



Access 2013 is using Microsoft SharePoint 2013 to host the front end of the app and Microsoft SQL Server 2012 as its data storage technology. As a result, each item inside access app table is NOT list item but a database entry. If you delete an entry or massed up the content of the table, there is no easy way to restore from UI. In this blog, I will explain how to restore the Access app based on the Access 2013 architecture.

As we described in previous blog, each access app will have a real database table created on the database side. All the records are stored inside the database. We will use precious Access Apps named “HarryDevApp1” with two tables “Employee” and “Rating” as in the screen shot. You could find the database name like “db_2105d1af_e924_460f_a749_59376ae2a9fd” with two tables named “Access. Employee” and “Access.Rating” are created. At meantime, there are two individual logins named “db_2105d1af_e924_460f_a749_59376ae2a9fd_custom” and “db_2105d1af_e924_460f_a749_59376ae2a9fd_dbo” are also created as owners for these two databases. 




Now you might be able to identify the recover strategy already. If user request to backup or restore Access tables, we could follow the below procedure.


  • Identify the Access App database by click “File” from Access client as described from previous blog
  • Identify the tables inside the database like “Access. Employee”
  • Restore the table form previous desired time

Please note, there might be macro created by end users that will be translated into database trigger as described in previous blog. You might need to recover the trigger also if users messed up the macro. If you need to restore entire Access App, you might need to restore the entire Access database.
Posted by at
Labels:

10 comments:

  1. UnknownApril 22, 2014 at 12:14 AM

    You can use http://www.en.sharepointserverrecovery.net tool. This tool is repair your corrupted or damaged mdf files ,Compatible with SharePoint Server 2013, 2010 and 2007.

    ReplyDelete
    Replies
    1. chris woakesJanuary 26, 2020 at 11:45 PM

      All the documents and data can be extracted by this Sharepoint Data Recovery software with ease from damaged or corrupt SharePoint database. Complete Repair feature to recover and restore content database and its content in the uploaded documents like wikis, blogs and articles.

      Delete
  2. SunilMay 1, 2014 at 11:03 PM

    By using http://www.repairsharepoint.com tool you can effectively recover your all data from corrupt SharePoint 2013 without any original data loss.

    ReplyDelete
  3. UnknownSeptember 3, 2014 at 9:30 PM

    SharePoint Server can damage or corrupted due to so many reasons like: virus attack, sudden system shutdown, hardware/software malfunctioning etc. Try to extract SharePoint file database with Recovery software of SharePoint. Download it here:- http://www.undeletepcfiles.com/sharepoint-database-recovery.html/

    ReplyDelete
  4. UnknownSeptember 11, 2014 at 11:48 PM

    If you have facing any problem of corrupt SharePoint database, then you can effectively repair and recover your all files from SharePoint database successfully. Go to :- http://www.filesrecoverytool.com/sharepoint-database-repair.html/

    ReplyDelete
  5. UnknownSeptember 12, 2014 at 9:24 PM

    Get hassle free SharePoint database recovery done with this user-friendly tool tool. It will repair your corrupt, damaged SharePoint Server MDF database.

    So Try:- http://www.recoverydeletedfiles.com/sharepoint-server-data-recovery.html/"

    ReplyDelete
  6. johncthomasJuly 28, 2015 at 3:00 AM

    Another Sharepoint Recovery software which can easily and safely and efficiently repair SQL Server files and SharePoint databases to get back all the important business data, documents, metadata and site content on SharePoint server from damaged SharePoint database.

    Go through: http://www.softmagnat.com/sharepoint-recovery.html


    ReplyDelete
  7. AnonymousNovember 27, 2015 at 9:23 PM

    A professional utility which safely and efficiently repair SQL Server files and SharePoint databases to get back all the important business data, documents, metadata and site content on SharePoint server from damaged SharePoint database.

    To download visit:- http://www.mannatsoftware.com/stellar-phoenix-sharepoint-recovery.html

    ReplyDelete
  8. UnknownApril 5, 2016 at 11:46 PM

    http://arrozinhoii.blogspot.in/2015/08/technical-recruiters-need-sharepoint_43.html?showComment=1459925163400#c217190621400762979

    ReplyDelete
  9. UnknownJune 21, 2016 at 2:04 AM

    Hi, Very nice description about SharePoint Development Phoenix.
    I like your web blog.Because whenever i come into your web blog
    then i always get the new interesting and important information in your web blog.

    Thank You
    SharePoint Development Phoenix

    ReplyDelete

Subscribe to: Post Comments (Atom)