Monday, February 27, 2012

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.


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.


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.


  1. SharePoint Server is an solution for MS SharePoint database administrators to resolve the corruption issues. The software extracts files, folders and documents from MS SharePoint Server making all the MDF data accessible.

    Read More Solution:-

  2. Powerful Sharepoint database repair Tool quickly and easily recover all MDF file items from corrupt database.The software is also supported by all versions of MS SharePoint Server compatible with all MS SQL Server 2000/ 2005/ 2008, 2008 r2 and 2012. User can get more information,
    Visit here:-

  3. SharePoint data Recovery is fast and efficient solution to repair your valuable SharePoint databases.This software provides the preview of data before its actual recovery and uploads the repaired database back to the SharePoint Server. Moreover, the software creates log report of all the activities during SharePoint repair.

    See full info :-