Microsoft KB Archive/925190

Knowledge Base

How to move a WMSDE content database that resides on a Windows SharePoint Services 2.0 server to a Windows SharePoint Services 3.0 server

Article ID: 925190

Article Last Modified on 5/14/2007

---

APPLIES TO

• Microsoft Windows SharePoint Services 3.0

---

INTRODUCTION

This article describes how to move a Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE) content database that resides on a Microsoft Windows SharePoint Services 2.0 (WSS) server to a Microsoft Windows SharePoint Services 3.0 (WSS 3.0) server.

When you move the WSS database to the WSS 3.0 server, the WSS database is upgraded to WSS 3.0. This occurs when you attach a WSS 3.0 Web application.

MORE INFORMATION

To move a WMSDE content database that resides on a WSS server to a WSS 3.0 server, follow these steps:

1. Use the Prescan.exe tool to scan the WMSDE content database on the WSS server.
   
   Note You must run the Prescan.exe tool on the WSS database to prepare the database to be added to the WSS 3.0 Web application.
   
   To use the Prescan.exe tool to scan the WSS database, follow these steps:
   1. Use an account that has administrative permissions to log on to the WSS server.
   2. Copy the Prescan.exe tool on the WSS 3.0 server to a folder on the WSS server.
      
      Note The Prescan.exe tool is located on the WSS 3.0 server in the following folder:

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

   3. Click Start, click Run, type cmd, and then click OK.
   4. Locate the folder to which you copied the Prescan.exe tool.
   5. At the command prompt, type the following command to scan the database:

      prescan /all

2. Use the Osql command to connect to the WSS database. To do this, follow these steps:
   1. At the command prompt, type the following command, and then press ENTER:

      Osql –S Servername\sharepoint -E

      Note In this command, Servername is the name of the WSS server.
   2. At the 1> prompt, type the following command, and then press ENTER:

      EXEC sp_detach_db contentDB name

      Note In this command, contentDB name is the name of the content database.
   3. At the 2> prompt, type Go, and then press ENTER.

   Note You may receive a message that resembles the following:

   database is in use and cannot be detached

   If you receive this error message, type the following commands at the command prompt in the order in which they are presented.

   • net pause mssql$sharepoint
   • net continue mssql$sharepoint
3. On the WSS 3.0 server, create the following folder structure under the Windows folder:

   SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

4. Copy all the .mdf and .ldf files that are located in the WSS database to following folder on the WSS server:

   WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

5. Use an account that has administrative permissions to log on to the WSS 3.0 server.
6. On the WSS 3.0 server, download and install the Microsoft SQL Server Native Client and the Sqlcmd utility. These tools are available in the latest feature pack for Microsoft SQL Server 2005.
   
   For more information about the feature pack for Microsoft SQL Server 2005, visit the following Microsoft Web site:

   http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

7. On the WSS 3.0 server, run the following command at the command prompt:

   sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

8. At the 1> prompt, type the following command, and then press ENTER:

   EXEC sp_attach_db @dbname = N'contentDB name', @filename1 = N'D:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\contentDB name_1.mdf', @filename2 = N'D:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data \contentDB name_1_log.ldf’

   Note In this command, contentDB name is the name of the content database.
9. At the 2> prompt, type Go, and then press ENTER:
10. On the WSS 3.0 server, create a Web application to attach to the database.
    
    For more information about how to create a Web application in WSS 3.0 server, see the administrative documentation.
    
    If you have already created a new Web application, you must use the Manage Content Databases page to remove the content database from the Web application. This lets you add the migrated database from the WSS server. To do this follow these steps:
    1. On the WSS 3.0 server, click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
    2. On the Central Administration page, click Application Management.
    3. On the Application Management page, click Content Databases.
    4. On the Manage Content Databases page, click the Web application that you want.
    5. Click the name of the new database that was created when you created the Web application.
    6. On the Manage Content Database Settings page, click to select the Remove content database check box, and then click OK.
11. Use the Stsadm.exe command-line tool to attach the WSS database to the Web application. Windows SharePoint Services does not support using the Manage Content Databases page to add a WSS database to a Web application. Therefore, you must use the Stsadm.exe command-line tool to add the Windows SharePoint 2.0 database to the Web application.
    
    To do this, follow these steps:
    1. At the command prompt, locate the following folder:

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

    2. At the command prompt, type the following command for more information about how to use the Stsadm.exe command-line tool.

       stsadm -help addcontentdb

       The following output is generated:

       stsadm.exe -o addcontentdb
                  -url url
                  -databasename <database name>
                  [-databaseserver <database server name>]
                  [-databaseuser <database username>]
                  [-databasepassword <database password>]
                  [-sitewarning <site warning count>]
                  [-sitemax <site max count>]

       Note In this text, url is the url of the WSS 3.0 Web application to which you want to add the database.

REFERENCES

For more information about WSS 3.0, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=5E4C222A-03A1-435A-A075-E47A28C9D6B8&displaylang=en

For more information about how to change the location of the Windows SharePoint Services database files, click the following article number to view the article in the Microsoft Knowledge Base:

843580 How to change the location of the Windows SharePoint Services database files

Additional query words: WSSv3

Keywords: kbhowto kbexpertiseinter KB925190

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.