subject: SharePoint Recovery When Database Repair Operation Fails [print this page] SharePoint Recovery When Database Repair Operation Fails
Does your Windows SharePoint Services website does not contains the parent Windows SharePoint Services website? Or few web pages do not have a parent website? Or the documents are missing parent document library? If you encountering any of the above issues with your MS SharePoint database, then in most cases the database is corrupted or damaged. In most cases of corrupted database, a database user encounters an error message while trying opening it. In such situations, if the user has maintained a database backup, then s/he is safe. However, if in case there is no backup availability, then s/he needs to run an inbuilt repair operation databaserepair. This database repair operation automatically detects and repairs most orphaned items in content database. While the operation is successful in most cases, it might fail in few situations. For such situations, only a third-party SharePoint Recovery application can help you repair the corrupted database.
Cause:
Few reasons responsible for corruption of any MS SharePoint databases are:
Malicious software (virus)
Unstable/Corrupt Operating system
Closing database while it is performing some task
Application damage
Few Common error messages that pop up when a database becomes corrupt are discussed underneath:
The file is corrupt and cannot be opened
The file is corrupt and cannot be restored
The page has encountered a critical error
Few Prevention Techniques:
Always create a complete online backup of your database on regular bases
Never leave the database open, with no body to monitor it
Never close the database when some operation is being performed
Scan your PC without an updated anti-virus
However, if the user has not followed above prevention techniques and the database is corrupted, then s/he needs to follow the below steps:
Use backup as the first remedy to overcome corruption
In case of database backup unavailability, use databaserepair operation
If that also fails, then use a third-party SharePoint Recovery utility
SharePoint Recovery Tool Information
A SharePoint Database Recovery utility helps a SharePoint DBA to overcome logical corruption in all cases. Such recovery tools use advanced, yet safe methods to repair a corrupted database. These SharePoint Database Recovery utilities help in recovering all kinds of information, such as, permissions, part links, metadata, and metadata.
