SharePoint 2007: The Definitive Guide

Perform Preupgrade Steps

Before we start upgrading our environment, we need to make sure that we have a rollback plan and that everything that we will need during the upgrade will be in place.

One of the first things that you should do is make sure that you have a complete backup of your current environment. In order to ensure that you can recover your existing environment, you must back up the databases that are used by Microsoft SharePoint Portal Server 2003, as listed in Table 24-2.

Figure 24-3. Enabling ASP.NET v2.0.50727

Table 24-2. SharePoint Portal Server 2003 database structure

Database type	Database name	Notes
Configurations Database	xxx_config_db	Required; one per farm
Site Database	xxx_SITE	Required; one per portal site
Profile Database	xxx_PROF	Required; one per portal site
Component Settings Database	xxx_SERV	Required; one per portal site
Single Sign-On Database	xxx_SSO	Optional; one per farm in case you have Single Sign-On implemented
Content Databases	STS_db_server_name_ID	Optional; there can be more than one, depending on the number of sites in your environment and their content

Tip

The database names in the previous table are samples of the default naming conventions. Your database names may vary depending on your implementation.

You can also use the SharePoint Portal Server 2003 backup and restore utility to generate a backup of your environment.