Microsoft KB Archive/828910

= Databases are not removed from SQL Server when you remove Windows SharePoint Services =

Article ID: 828910

Article Last Modified on 9/26/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services
 * Microsoft Windows SharePoint Services 3.0

-





SYMPTOMS
When you remove Microsoft Windows SharePoint Services from a front-end Web server, the databases that are used by Windows SharePoint Services are not removed from the remote back-end server that is running Microsoft SQL Server.



CAUSE
This behavior may occur if all the following conditions are true, in the order that they are presented:
 * 1) You install Windows SharePoint Services by using the Server Farm option.
 * 2) The Windows SharePoint Services Web site is extended, and a remote server that is running SQL Server is used to store data and manage the Windows SharePoint Services Web site.
 * 3) You perform a full removal of Windows SharePoint Services from the server.



RESOLUTION
To resolve this issue, manually delete the Windows SharePoint Services databases on the server that is running SQL Server. To do so, follow these steps:
 * 1) Start SQL Server Enterprise Manager.
 * 2) Expand Microsoft SQL Servers, expand SQL Server Group, expand the appropriate server, and then expand Databases.
 * 3) Right-click each Windows SharePoint Services SharePoint database, and then click Delete.

Note By default, the configuration database is named STS_config, and the content databases are named STS_ _, where  is a number (for example, STS_MyServer_1).
 * 1) Click Yes when you are prompted to confirm the deletion.
 * 2) Quit Enterprise Manager.



MORE INFORMATION
Windows SharePoint Services databases are not removed from SQL Server when you remove Windows SharePoint Services from the server, regardless of if you install Windows SharePoint Services by using the Typical Installation option or by using the Server Farm option.

For more information about Windows SharePoint Services, visit the following Microsoft Web site:

http://technet.microsoft.com/windowsserver/sharepoint/default.aspx

Additional query words: WSSv3 WSSv2

Keywords: kbinfo kbprb KB828910

-

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

© Microsoft Corporation. All rights reserved.