Migrating MOSS Databases from Testing to Production

The following procedures assumes that two WFE exist: one for serving content and the other an indexing server. This procedure should successfully migrate from testing to production using database backup and restore for the MOSS applications.

1. In SQL Server Enterprise Manager, backup all Office SharePoint Server 2007 related databases from the previous database server.

2. On the front-end web server, disconnect MOSS from the far using the Sharepoint Products and Technologies Configuration Wizard.

3. In SQL Server Enterprise Manager, restore all Office SharePoint Server 2007 related databases except the configuration database and the central administrator content database and the search databases to the production database server.

Central Administration Configuration (Front-End Web Server and Index Server)

1. On the front-end web server, run the Sharepoint Products and Technologies Configuration Wizard.

a. Do not connect to an existing server farm. Enter the database and server name information for the production database server.

b. After the configuration wizard has completed, do not accept the offer to create a shared service provider or portal site. Instead create it manually.

c. Next, disconnect the index server from the farm using the same method as above.

d. Connect to the new pilot site from the index server.

e. Turn on the indexing service for the index server.

2. Restore the Shared Service Provider.

a. From the Application Management page click Create or configure this farm's shared services.

b. Click Restore SSP.

c. Add the necessary configuration information for the Shared Service Provider web application, My Site web application, Shared Service Provider database name and search database name.

d. Click OK.

e. Start the search crawl from the Search Setting page in the Shared Service Provider administrator console.