Description of a new command-line operation that is available for the Spsadm.exe command line tool that you can use to clean up orphaned items in the configuration database in SharePoint Portal Server 2003 (918742)



The information in this article applies to:

  • Microsoft SharePoint Portal Server 2003

INTRODUCTION

This article describes a new functionality in Microsoft Office SharePoint Portal Server 2003 that lets you clean up orphaned items in the configuration database. In certain scenarios, the configuration database may contain orphaned items. This article describes a new repairorphans command-line operation that is available for use with the Spsadm.exe command-line tool. You can use with the Spsadm.exe command-line tool with the repairorphans operation to clean up orphaned items in the configuration database.

The repairorphans operation removes, and then re-adds the PortalSiteName_SITE content database. By doing this, orphaned items that may exist for the PortalSiteName_SITE content database are removed from the configuration database.

In scenarios where a content database in Microsoft Windows SharePoint Services becomes corrupted, you may have to use the Stsadm.exe command-line tool to detect, and then delete orphaned items. After you use the Stsadm.exe command-line tool to repair content databases in Windows SharePoint Services, use the procedure that is described in this article to clean up orphaned items that may be present in the configuration database in SharePoint Portal Server 2003.

MORE INFORMATION

How to obtain the hotfix

This issue is fixed in the SharePoint Portal Server 2003 post-Service Pack 2 Hotfix Package that is dated May 30, 2006. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

918741 Description of the SharePoint Portal Server 2003 post-Service Pack 2 hotfix package: May 30, 2006

Information about the hotfix

The hotfix adds a new repairorphans command-line operation that you can use with the Spsadm.exe command-line tool to clean up orphaned items in the configuration database. The repairorphans operation uses the portalURI parameter. The portalURI placeholder is the Uniform Resource Identifier (URI) of the portal site.

The syntax that the Spsadm.exe command-line tool and the repairorphans operation use is as follows:

spsadm repairorphans portalURI

How to clean up orphaned items in SharePoint Portal Server 2003

To use the Spsadm.exe command-line tool with the repairorphans operation to clean up orphaned items in the configuration database, follow these steps:
  1. Click Start, click Run, type cmd in the Open box, and then click OK.
  2. Type the following line at the command prompt. , and then press ENTER:

    cd /d %programfiles%\Sharepoint Portal Server\Bin

  3. Type the following line at the command prompt, and then press ENTER:

    spsadm repairorphans portalURI

    For example, if the URI of the portal site is http://Server1, type the following line at the command prompt, and then press ENTER:

    spsadm repairorphans http://Server1

REFERENCES

For more information about how to detect and delete orphaned items in content databases in Windows SharePoint Services, click the following article number to view the article in the Microsoft Knowledge Base:

918744 Description of a new command-line operation that you can use to repair content databases in Windows SharePoint Services


Modification Type:MinorLast Reviewed:7/26/2006
Keywords:kbSharePtPortalSvr2003preSP3fix kbbug kbfix kbQFE kbExpertiseInter kbhotfixserver kbpubtypekc KB918742 kbAudITPRO