How to Recover Corrupted SharePoint Database?
MS Office SharePoint Server (MOSS) is also known as SharePoint and it is server software. It is well known database application which is widely used. It is actually associated with document management, intranet and content management. It uses SQL server technology for storing informations such as site configuration and content management. It serves multipurpose uses such as manages websites, social networking sites, web portals, content, business intelligence tooling, documents etc. In order to create organizational intranets, this is the most important software. Using this, you will have great help while building any collaborations sites, content management sites etc. It provides multipurpose set of Web technologies supporting common technical infrastructure. It integrates with office suite closely thus possessing process integration, workflow automation capabilities and system integration. SharePoint helps in sharing data easily therefore allowing users for accessing data over wide network. The data are generally saved in MDF format in SharePoint. SharePoint Server helps in saving primary data files which stores and saves the entire information such as lists, content database, workspace, documents etc in MDF files. But similar to other cases, SharePoint Database also faces several error consequences leading to corruption in SharePoint database.
Reasons which cause corruption of SharePoint file: MDF database of the SharePoint sever gets corrupted due to the below mentioned reasons. This corruption results in inaccessibility of data. • Using MDF files while database is running. • When the SQL database is running, the disk space is not free. • Database hits with virus attack or Trojan infection. • Due to header corruption. • Crashing of hard disk drive. • Media corruption or bad sector in the storage media.
Unexpected system shutdown in the system due to power failure. • Database is running in 'suspected' mode or log files are deleted. • Accidentally deleting share point web portals. • Existence of any bug in SharePoint leads to corruption. • Accessing or copying of MDF files when database is running. • Abnormal internet speed on the system. During, SharePoint Server downtime users suffer a lot of problem for carrying out their important processes. Thus, they need to resolve the errors as soon as they detect and require a reliable solution in order to solve these issues. Users try to recover their corrupted SharePoint database by using manual method known to them but those methods do not prove to be effective all the time leading to users in abrupt condition. •
Suggested Solution: In order to make successful Share Point database recovery, the viable solution is for opting third party recovery tool. SharePoint Repair Tool is especially designed to repair SharePoint files from corrupted or damaged MDF database. It is the most efficient and accurate tool which scans the scans the corrupted database files effectively and recovers the objects which are inaccessible in MDF database files. It rebuilds data and helps in uploading to the SharePoint Server again. It enables users in retrieving share point database such as tables, documents, indexes, stored procedures and labels etc easily. It provides two repairing mode which is Raw File Recovery and Live SQL instance mode. In raw file recovery mode, users are able to restore labels and other files and in Live SQL instance mode, users recover their files while MS SharePoint Server is down. It tracks the user’s activities and thus modifies the security across the sites for reducing the time spent to analyze audit logs and report back to the content owners. When data is retrieved then they are listed in tree form and you are provided the option for previewing them. Using this tool, you can recover SharePoint database with an ease as it has simple and user friendly interface so don’t require any technical knowledge. This tool is compatible with MS SharePoint Server 2007 and 2010 and OS such as Windows Vista, Server 2003, XP, 2000, NT, and 9x.
Steps to Repair:
Step 1: Launch the SharePoint Repair Tool and an interface appears. The interface screen will display two options for SharePoint data recovery: 'Complete Repair' and 'Document Recovery' so select as per your need.
Step 2: If selected 'Complete Repair' then the screen shows the options to select and search SQL Server (.MDF) files. Click on 'Select File' for repairing SharePoint database. When you don’t know database actual path then click on the 'Search File' option for locating MDF file in a specific drive. When finished selecting then go for scanning process.
Step 3: After scanning, the software generates a tree of all SharePoint database tables and display them on the left pane. If you need to preview then select the table in the tree and you will able to see in the right pane. Now, click on 'Repair' in order to begin repairing process for the selected database.
Step 4: After clicking on 'Repair', dialog box appears. Then, specify the SQL Server name/Instance name and the desired destination path. Now, click on the 'Browse' option for choosing the destination path. Then, click on 'OK' button.
Step 5: When this process is completed, you will find a dialog box that displays 'Recovered file’ message is saved at the desired location. This ensures successful completion of Recovery Process. Now, click on 'OK' button.
Step 6: After this, another dialog box appears which will ask you whether you want to attach the repaired database to the web application. When clicked on 'Yes' button, the above dialog box is displayed. In the web application URL, type the name of the corrupted database and SQL Server Instance name. Then, click on 'OK' button and proceed. On completion of the process, you can access the repaired database just by opening the web application.
Free download software: http://sharepoint.filerepairtool.net/