O'Reilly logo

SharePoint 2007: The Definitive Guide by Christopher J. Regan, Piotr Prussak, Christopher Pragash, Joris Poelmans, Nilesh Mehta, Jason Medero, Michael Lotter, Murray Gordon, Bob Fox, Christopher M. Buechler, James Pyles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Enabling ASP.NET v2.0.50727

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required