Database Upgrade Failures

When a SQL Server is upgraded to version 6.0, all of its databases are automatically upgraded by the setup program. However, under some conditions it may not be possible to upgrade a particular database to version 6.0. This can occur, for example:

• When the database name is a SQL Server 6.0 reserved word or keyword
• When the database is set to read-only or offline

Note You should always run the chkupg utility prior to upgrading. This utility detects these conditions, allowing you to correct them prior to upgrading. For information on using chkupg, see Chapter 4, Server Installation.

When one of these conditions is encountered during a server upgrade a message is displayed. After the server upgrade completes you can determine the affected database by reviewing all the report files (files ending in the .OUT filename extension), correct the condition that prevented the database upgrade, and then use the sp_db_upgrade system procedure to upgrade the database to version 6.0.

    To upgrade a database

1. Determine the affected database by reviewing the .OUT files.

   Report files ending in the .OUT filename extension are stored in the \SQL60\INSTALL directory. Review all .OUT files, especially CHKUPG.OUT and UPGRADE.OUT.

2. Correct the condition that prevented the database upgrade.
3. From a query interface (for example, from ISQL/w), type:

   sp_db_upgrade dbname

   where

   dbname

   Is the name of the database to be upgraded.

For example:

sp_db_upgrade pubs