Installing Microsoft SQL Server version 6.5 requires approximately 96 MB of disk space, plus 1 to 15 MB for SQL Server Books Online. Upgrade requirements are as follows.
Upgrading from |
Disk space required for SQL Server 6.5 |
Free space required in the master database |
Disk space required for SQL Server Books Online |
|---|---|---|---|
| New installation | 56 MB | 25 MB | 1 MB if run from CD
15 MB installed |
| SQL Server 6.0 | 20 MB | 2 MB | 1 MB if run from CD
15 MB installed |
| SQL Server 4.2x | 65 MB | 9 MB | 1 MB if run from CD 15 MB installed |
In all cases, the required disk space must be available on the drive where SQL Server is located. The setup program checks for required disk space by using somewhat smaller values, so you must manually confirm that enough disk space is available.
The setup program will automatically expand the master database and the MASTER device as required.
Before you begin an upgrade, run the CHKUPG65.EXE utility, which checks that database status is acceptable, that all necessary comments exist in syscomments, and that there are no keyword conflicts. CHKUPG65.EXE writes this information to an output file. Review the report and take any action the report indicates is necessary to prepare the existing installation for an upgrade. For more information about running the CHKUPG65.EXE utility, see Running the CHKUPG.EXE Utility. Note that CHKUPG.EXE is now called CHKUP65.EXE, but the functionality has not changed.
When upgrading to SQL Server 6.5 from version 6.0 or 4.2x, the Open Databases configuration option must be equal to or greater than the total number of databases on your system, including the master, model, tempdb, and pubs databases. If the Open Databases configuration option is less than the total number of databases on your system, the upgrade will fail. You can change the Open Databases configuration option by using SQL Enterprise Manager or the sp_configure system stored procedure.
Note Earlier versions of Microsoft SQL Server must be shut down before installing or upgrading to version 6.5. Also, before an upgrade, stop replication and make sure that the log is empty. It is recommended that the system administrator's default database be set to master.
If you are upgrading from an earlier version of SQL Server and you have databases that contain objects that rely on the setting SET QUOTED_IDENTIFIER ON, you should run SETUP.EXE from the command line using the following syntax:
setup /t SetQuotedId = ON
For more information about running SETUP.EXE from the command line, see "Performing an Unattended Installation" in Microsoft SQL Server Setup.