A new operation has been added to the Stsadm.exe tool to repartition a site collection of a Windows SharePoint Services 3.0 content database

Microsoft Windows SharePoint Services 3.0 includes the Stsadm.exe tool for command-line administration of Windows SharePoint Services servers and sites. We have added a new operation that you can use to repartition a site collection in a content database.

To obtain this new operation, apply hotfix 939188. Then, use the mergecontentdbs operation to repartition a site collection in a content database.

How to obtain the hotfix

For more information about hotfix 939188, click the following article number to view the article in the Microsoft Knowledge Base:

How to use the mergecontentdbs operation

To repartition a site collection in a content database, use the following syntax for the mergecontentdbs operation at a command prompt: Note The following table lists the values for the operation parameter. The following is a sample Stsadm.exe command line for the mergecontentdbs operation:

Additional information

A new -databasename <databasename> parameter has been added to the Enumsites operation.

For more information about the Enumsites operation, visit the following Microsoft Web site: For more information about the Stsadm.exe command-line tool, visit the following Microsoft Web site: To make sure that you have the correct permissions to repartition site collections, temporarily grant yourself Full Control permissions in "Policy for Web Application."

Additionally, make sure that your account is a box administrator on the server that is running Microsoft SQL Server, or make sure that your account is granted the Database Owner fixed database role for all SharePoint products and technologies databases.

To do this, follow these steps:

1. Click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. Click the Application Management tab, and then click Policy for Web Application.
   
   Note Determine whether the account is already listed, and then determine which permission level the account has.
3. In Policy for Web Application, click Add Users.
4. On the Add Users page, click the Web application that you will use to run the command, and then click Next.
5. In the Choose Users box, add the account that you will use to log on when you run the command.
6. In the Choose Permissions area, select Full Control, and then click Finish.

Note If you do not have the correct permissions to perform the operation, you will receive an error message that resembles the following error message: After you successfully repartition the sites, use the previous steps to remove or to change your account permission level by using "Policy for Web Application," depending on how you want your permissions to be configured. If your account is used for other services, reset it to the original permission level.