Microsoft KB Archive/905386

= How to move the databases that are used by Windows SharePoint Services and by Project Server 2003 to a computer that is running SQL Server =

Article ID: 905386

Article Last Modified on 9/22/2005

-

APPLIES TO


 * Microsoft Office Project Server 2003
 * Microsoft Windows SharePoint Services

-





SUMMARY
To move the databases that are used by Microsoft Windows SharePoint Services and by Microsoft Office Project Server 2003 to a new computer that is running Microsoft SQL Server 2000, you must complete the following tasks:


 * Back up the Windows SharePoint Services database and the Project Server 2003 database on the old computer that is running SQL Server.
 * Restore the Windows SharePoint Services database and the Project Server 2003 database on the new computer that is running SQL Server.
 * Configure Windows SharePoint Services.
 * Configure Project Server 2003 users on the new computer that is running SQL Server.
 * Use the Site Editor utility to modify the name of the new computer that is running SQL Server.

Additionally, this article makes the following assumptions about the new computer that is running SQL Server:


 * SQL Server 2000 is installed and has at least service pack 3a (SP3a) installed.
 * Windows SharePoint Services is installed.
 * Project Server 2003 is installed.



INTRODUCTION
This step-by-step article describes how to move the databases that are used by Windows SharePoint Services and by Project Server 2003 to a new computer that is running Microsoft SQL Server. Use the procedure that is described in this article if one of the following conditions is true:
 * You originally installed Windows SharePoint Services, Project Server 2003, and SQL Server on the same computer. Now, you want to use a remote computer that is running SQL Server for database storage.
 * You originally installed Windows SharePoint Services and Project Server 2003 on one computer and SQL Server on another computer. Now, you want to use a different remote computer that is running SQL Server for database storage.

Back up the databases
Back up the databases that are used by Windows SharePoint Services and by Project Server 2003 on the old computer that is running SQL Server. You must back up the following databases:
 * The Windows SharePoint Services content database

By default, the name of the content database starts with the letters &quot;STS&quot; and includes the name of the server. For example, the content database may be named STS_ _1.mdf. There may be more than one content database.

Note You do not have to back up the Windows SharePoint Services configuration database.
 * The database that is used by Project Server 2003

By default, the name of the database is ProjectServer.

Use the SQL Server backup tools to back up the databases. To do this, follow these steps:  Create a new folder to store the databases that you back up. Back up the Windows SharePoint Services content database. To do this, follow these steps:  Start SQL Server Enterprise Manager. Expand Microsoft SQL Servers, expand the server group, expand the appropriate server, and then expand Databases. Right-click the Windows SharePoint Services database that you want to back up, point to All Tasks, and then click Backup Database. Under Backup, click Database-complete. If a path is displayed in the Destination box, click the path, and then click Remove.</li> Click Add, and then click File name. Specify the location of the folder that you created in step 1 and the file name of the backup file. Use a file name that is the same as the name of the database.</li> Click OK two times.</li> Click OK when you receive the message that states that the backup operation completed successfully.</li> Repeat step 2c to step 2h for each Windows SharePoint Services content database that you want to back up.</li></ol> </li> Back up the database that is used by Project Server 2003. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Right-click the Project Server 2003 database that you want to back up, point to All Tasks, and then click Backup Database.</li> Under Backup, click Database-complete.</li> If a path is displayed in the Destination box, click the path, and then click Remove.</li> Click Add, and then click File name. Specify the location of the folder that you created in step 1 and the file name of the backup file. Use a file name that is the same as the name of the database.</li> Click OK two times.</li> Click OK when you receive the message that states that the backup operation completed successfully.</li></ol> </li></ol>

Restore the databases
Restore the backed up databases to the new computer that is running SQL Server. Use the SQL Server backup tools to restore the databases. To do this, follow these steps: <ol> Copy the backup files from the old computer that is running SQL Server to a folder on the new computer that is running SQL Server.</li> Restore the database that is used by Windows SharePoint Services. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Start SQL Server Enterprise Manager.</li> Expand Microsoft SQL Servers, expand the server group, and then expand the appropriate server.</li> <li>Right-click Databases, point to All Tasks, and then click Restore Database.</li> <li>Click the General tab.</li> <li>In the Restore as database box, specify the name of the database.</li> <li>Next to Restore, click From device.</li> <li>Under Parameters, click Select Devices.</li> <li>Click Add, specify the name and the location of the backup file in the File name box, and then click OK two times.</li> <li>Click Restore backup set, click Database-complete, and then click OK.</li> <li>Click OK when you receive the message that states that the restore operation completed successfully.</li> <li>Repeat step 2c to step 2j for each Windows SharePoint Services content database that you want to restore.</li></ol> </li> <li>Restore the database that is used by Project Server 2003. To do this, repeat step 2c to step 2j.</li></ol>

Configure Windows SharePoint Services
You can configure Windows SharePoint Servives on the existing Windows SharePoint server or on a new server. To dothis, follow these steps: <ol> <li>Create a new configuration database. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Start SharePoint Central Administration.</li> <li>Under Server Configuration, click Set configuration database server.</li> <li>On the Set Configuration Database Server page, specify the name of the server in the Database server box. Then, type the name that you want for the new configuration database in the SQL Server database name box.</li> <li>Under Database connection type, click SQL authentication (less secure), and then type the user name and the password of the appropriate SQL Server user account.</li> <li>Click OK.</li></ol> </li> <li>Extend the Default Web Site, create a content database, and then add the content database that you restored to the virtual server. Then, remove the content database that was created when you extended the Default Web Site. To do this, follow these steps: <ol> <li>Extend the Default Web Site, and then create a content database. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Under Virtual Server Configuration on the Windows SharePoint Services Central Administration page, click Extend or upgrade virtual server.</li> <li>On the Virtual Server List page, click Default Web Site.</li> <li>In the Provisioning Options area of the Extend Virtual Server page, click Extend and create a content database.</li> <li>In the Application Pool area, click Create a new application pool, and then type a name for the application pool. Click Predefined, and then click Network Service.</li> <li>In the Site Owner area, specify the user name and the e-mail address of the site owner.</li> <li>In the Database information area, click to clear the Use default content database server check box. Type a name for the content database in the Database name box, and then type the user name and the password of the appropriate SQL Server user account in the Database account user name and Database account password boxes.

Note Make sure that the name that you use for this content database is different from the name of the content database that you restored from backup.</li> <li>Click OK, and then click OK on the Virtual Server Successfully Extended page.</li></ol> </li> <li>Add the content database that you restored from backup. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Under Virtual Server Management on the Virtual Server Settings page for the Default Web Site, click Manage content databases.</li> <li>Under Content Databases, click Add a content database.</li> <li>In the Database Information area of the Add Content Database page, click Specify database server settings.</li> <li>Type the name of the server in the Database server box.</li> <li>Type the name of the content database that you restored from backup in the Database name box. Then, type the user name and the password of the appropriate SQL Server user account in the Database account user name and Database account password boxes.</li> <li>In the Database Capacity Settings area, type the number that you want in the Number of sites before a warning event is generated box. Then, type the number that you want in the Maximum number of sites that can be created in this database box.</li> <li>Click OK.</li></ol> </li> <li>Remove the content database that was created when you extended the Default Web Site. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Under Virtual Server Management on the Virtual Server Settings page for the Default Web Site, click Manage content databases.</li> <li>Click the content database that was created when you extended the Default Web Site.</li> <li>In the Database Information area, type the user name and the password of the appropriate SQL Server user account in the Database account user name box.</li> <li>In the Remove Content Database area of the Manage Content Database Settings page, click to select the Remove content database check box, and then click OK two times.</li></ol> </li></ol> </li></ol>

Configure Project Server 2003 user accounts
To configure Project Server 2003 user accounts on the new computer that is running SQL Server, follow these steps <ol> <li>Start SQL Server Enterprise Manager.</li> <li>Delete the MSProjectServerUser user account and the MSProjectUser user account from the restored ProjectServer database. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Expand Microsoft SQL Servers, expand SQL Server Group, expand the appropriate server, and then expand Databases.</li> <li>Expand the ProjectServer database.</li> <li>Click Users.</li> <li>Right-click MSProjectServerUser, click Delete, and then click Yes to confirm the deletion.</li> <li>Right-click MSProjectUser, click Delete, and then click Yes to confirm the deletion.</li></ol> </li> <li>Create a new MSProjectServerUser user account and a new MSProjectUser user account. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Right-click User, and then click New Database User.</li> <li>In the Login name box, click MSProjectServerUser.</li> <li>Under Database role membership, click to select the MSProjectServerRole check box, and then click OK.</li> <li>Right-click User, and then click New Database User.</li> <li>In the Login name box, click MSProjectUser.</li> <li>Under Database role membership, click to select the MSProjectRole check box, and then click OK.</li> <li>Quit SQL Server Enterprise Manager.</li></ol> </li></ol>

Use the Site Editor utility to modify the name of the new computer that is running SQL Server
To use the Site Editor utility to modify the name of the new computer that is running SQL Server, follow these steps: <ol> <li>Download the Site Editor utility (Editsite.exe). To do this, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=123a740b-9512-4a21-89fb-5a20819c20c7

</li> <li>Run the Site Editor utility on the computer that is running Project Server 2003.</li> <li>Type the name of the new computer that is running SQL Server in the SQL Server box, and then click Save.</li> <li>Click Yes, and then click OK.</li> <li>Click Exit.</li></ol>

<div class="references_section">