SharePoint Database Recovery When Stsadm.exe Does Not Restore Database

The stsdm.exe is a very powerful and useful command-line utility of Microsoft SharePoint Server. It lets you perform a wide range of operations on your SharePoint Server database, which includes backup and restore database. You can use stsadm.exe -o backup to backup and stsadm.exe –o restore to restore the database, in case of database corruption and can avoid needs of SharePoint Recovery solutions.

Stsadm.exe backup utility helps you handle corruption in a number of situations, but it does not backup user profile information. This issue usually occurs on Microsoft SharePoint Server 2003 and 2007. You may run across this issue if the following conditions are true:

• You create backup of personal site using Stsadm.exe utility and then try to restore it.
• You create a new SSP (Shared Services Provider), which has a number of new SSP databases.

This issue can prove very harmful in case of database corruption. When database gets damaged, you can not restore the user profiles using the backup. At this point of time, you have to opt for SharePoint repair solutions.

Cause:

This is a design issue in Microsoft SharePoint Server. SharePoint 2007 stores user profile information in SSP database. Whereas, SharePoint 2003 stores the information in _PROF database that is used by portal application.

Resolution:

In order to create a complete backup of profile information, you must following the below actions:

• You must do complete backup of the SSP database and then restore it, in case of SharePoint 2007. In case you have concern of database damage in SSP database, and there is a backup that was taken before the point of corruption, you can restore complete SSP backup to get absolute information.
• You must create complete backup of the _PROF database, which is used by portal applications, in SharePoint 2003. The process may need that you also restore all the portal applications.

The above solutions are helpful if you take these things in consideration before creating the backup. If you have created backup earlier and facing database corruption now, then you have to fix it using SharePoint database repair solutions. It is best possible using advanced and effective commercial recovery applications.