How to estimate the disk space required for an upgrade from SQL Server version 6.5 to SQL Server 2000 (SQL Server Upgrade Wizard)

SQL Server Setup Help

SQL Server Setup Help

How to estimate the disk space required for an upgrade from SQL Server version 6.5 to SQL Server 2000 (SQL Server Upgrade Wizard)

Note  To run the SQL Server Upgrade Wizard, you must have an instance of Microsoft® SQL Server™ 2000 already installed on your computer.

To estimate the disk space required for an upgrade

  1. On the Start menu, point to Programs/Microsoft SQL Server-Switch, click SQL Server Upgrade Wizard, and then click Next.

  2. Select Named pipe; then click Next.

  3. In Export server (6.5), in the Server name box, enter the name of the local or remote computer on which SQL Server 6.5 resides.

  4. In the Administrator password ('sa') box, enter the sa password for SQL Server 6.5, and then click Next.

    Unless you have changed it, the system administrator password for SQL Server 2000 is blank.

  5. Include the databases to upgrade. Move any database not to include in the disk space estimation to the Exclude list, and then click Next.

  6. Select Use the default configuration or edit the default; then click Edit.

    The SQL Server Upgrade Wizard layout utility appears, showing the proposed layout of the SQL Server 2000 data files.

  7. Click Advanced.

  8. Click an object in the Proposed database layout box to view details in the Object details box.

  9. The Drive summary box shows the estimated size of all SQL Server 2000 data files and the free disk space left on all of the local fixed disks. On the Options menu, select Freespace includes 6.5 files to view the free space that would exist if the SQL Server 6.5 data files were deleted.

  10. Click Accept to return to the Database Creation dialog box.

  11. Click Cancel to quit the SQL Server Upgrade Wizard.