How to recover corrupt data from SharePoint Server farm

First you should know What is SharePoint Server Farm??

SharePoint Server Farm includes many servers or as few as two servers. A SharePoint server farm divided in to three categories: SMALL, MEDIUM, LARGE. You can choose one category as per your requirement. 

                               

              
              SharePoint Server Farm

Different Purposes of SharePoint Server Farm:

Front End Web Server: The Web server role provides Web content to clients.

Front End Application Server: The application server role provides Office SharePoint Server 2007 services such as servicing search queries, and crawling and indexing content.

SQL Database Server:  SQL Database Server save all content of SharePoint sites etc.

Domain controller: Through this we can provide authorization and authentication services to users.

Small server farm consists of two-server, one servers hosts the Web front end and the application services, while the second server hosts the SQL Server database.

A medium server farm consists of a database server, an application server running Office SharePoint Server 2007, and one or two front-end Web servers running Office SharePoint Server 2007 and IIS.

A large server farm consists of two or more clustered database servers, several  front-end Web servers running Office SharePoint Server 2007, and two or more application servers running Office SharePoint Server 2007.

If data of SharePoint Server farm get corrupted then it can be happen due to two main causes like:

1. SQL Server Database get corrupt
2. SharePoint Site get inaccessible

Due to this, you are not able to perform lots of activities such as:

• Not able to open SharePoint Site
• Not able to open content database
• Not able to open SQL Server database
• Not Perform Any Activity at all & many more..

SharePoint Inbuilt utilities helps you to recover corrupt SharePoint data like

1. stsadm.exe
2. Central Administration user interface
3. SQL Server backup

But Sometimes these utilities are not able to perform complete SharePoint data recovery. In this case, I have another suggestion that is use of SharePoint Server Recovery Software. These Software’s recover data in most of the SharePoint corruption error conditions. No matters how big the farm, Software also recovers data from SharePoint Server Farm.

What happened when SharePoint Site Collection get corrupted

As we all knows SharePoint site collection is the collection of SharePoint sites. Sometimes, we cannot access our SharePoint site collection that means something is really messed up with SharePoint site collection. After done some research on Google, I found two possibilities of this SharePoint site collection behavior - either SharePoint server isn't running properly or SharePoint site collection get corrupted. If SharePoint Site collection gets corrupted, then there is also a possibility of SharePoint Content database corruption because all the data of SharePoint site has been saved into the content database.

Uncountable reason behind these two possibilities:

• improper system shutdown
• SharePoint server malfunctioning
• software malfunctioning
• virus attacks
• Hardware Problem
• Connection break between SharePoint site & content database
• And many more…

If SharePoint server isn't running properly, you can fix it by re-installing SharePoint Server again.

Problems occur when SharePoint site collection gets corrupt:

• Cannot perform any activity on site collection
• Cannot access full SharePoint site collection
• Cannot access some sites of SharePoint site collection
• Cannot access your content database

To resolve this issue you should use SharePoint server in-built utilities to restore your SharePoint site collection, so the first thing that is very important for SharePoint administrators as well as for all users who used SharePoint server to understand what in-built utilities are and to know the best practices for how and when to run them. There are lots of in-built utilities available in SharePoint server which used in different conditions such as command line tool stsadm, SharePoint Central Administration, SQL server backups etc.

There is one another solution that is use of Third party SharePoint Server Recovery Software. User can easily use these software by given instruction just needs to download demo version. All software related information is available in help file of software. You can easily check the preview of your database in demo version.