Microsoft KB Archive/926321

= Error message when you try to restore a Windows SharePoint Services 3.0 site collection by using a different name: &quot;No content databases are available for this operation&quot; =

Article ID: 926321

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services 3.0

-



SYMPTOMS
You back up a Microsoft Windows SharePoint Services 3.0 site collection. When you try to restore this site collection by using a different name, you receive the following error message:

No content databases are available for this operation. Create a content database, and then try the operation again. To create a content database, click &quot;Content databases&quot; on the Application Management page, select the Web application to use, and then click &quot;Add a content database&quot;.



CAUSE
This issue occurs because the Windows SharePoint Services site collection that you are trying to restore contains GUID information that already exists in the content database.



RESOLUTION
To resolve this issue, use either of the following methods.

Method 1: Use the Stsadm.exe command-line tool to restore the site collection after you create a new content database
 Use an account that has administrative permissions to log on to the computer that is running Windows SharePoint Services 3.0. Click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration. On the Central Administration page, click Application Management. On the Application Management page, click Content databases. On the Manage Content Databases page, click Add a content database. Next to Web Application, click the Web application in which you want to add an existing content database. Configure the remaining options as appropriate, and then click OK. Use the Stsadm.exe command-line tool to restore the Windows SharePoint Services site. To do this, type the following command at a command prompt:

stsadm.exe -o restore -url  -filename

Note Stsadm.exe is located in the following folder:

Program Files\Common Files\Microsoft Shared\Web server extensions\12\BIN

</li></ol>

Method 2: Use the Stsadm.exe command-line tool together with the -overwrite parameter to restore the site collection
You can use the Stsadm.exe command-line tool to restore the site collection and to overwrite the GUID information in the content database. To do this, type the following command at a command prompt:

stsadm.exe -o restore -url  -filename   -overwrite

<div class="moreinformation_section">

MORE INFORMATION
For more information about parameters that you can use together with Stsadm.exe, type the following command at a command prompt:

stsadm.exe -help

For more information about operations that you can perform by using Stsadm.exe, type the following command at a command prompt:

stsadm.exe -help

In this command,  is the operation that you want to query.

Additional query words: WSSv3

Keywords: kbtshoot kbexpertiseinter kbprb KB926321

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.