Before Upgrading

Before you begin an upgrade:

• Back up all databases (including the master database) before upgrading the server.
• If any databases are read only, run sp_dboption and set the read only option to FALSE. For information on sp_dboption, see the Microsoft SQL Server Transact-SQL Reference.
• Run the CHKUPG.EXE utility, which checks that database status is acceptable, that all necessary comments exist in the syscomments system table, and that there are no keyword conflicts. CHKUPG.EXE creates a report file. Review the report and take any action the report indicates is necessary to prepare the existing installation for an upgrade.

  For more information, see Running the CHKUPG.EXE Utility later in this chapter.

• Check that there is adequate physical disk space for the upgrade.

  At least 50 MB of free disk space is required to upgrade from SQL Server 4.2x to SQL Server 6.0.

  The master database must have at least 7 MB free, but if that much database space is not available, the setup program automatically alters the master database to increase the space allocated to it. If necessary, setup also increases the size of the MASTER device (as long as adequate disk space is available).

• Check that no applications that could be using any of the SQL Server DLLs are running on the server you are going to upgrade. (These applications include SQL Server, SQL Monitor, and SQL Server client applications such as isql, SQL Administrator, and SQL Object Manager.) Also check that Microsoft® Word for Windows® and the Microsoft® Visual C++ development system are not running, and that no applications are using the Microsoft Visual C++ run-time library (MSVCRT20.DLL).

  In general, it is a good idea to make sure no applications are running on the server you are upgrading.

• Log on to the system under a user account that has administrative privileges.