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

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.x), in the Server name box, enter the name of the local or remote computer on which SQL Server 6.x resides.
4. In the Administrator password (‘sa’) box, enter the sa password for SQL Server 6.x; then click Next.

   Unless you have changed it, the system administrator password for SQL Server 7.0 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 7.0 data files.

7. Click Advanced.
8. Click an object in the Proposed 7.0 database layout box to view details in the Object details box.
9. The Drive summary box shows the estimated size of all SQL Server 7.0 data files and the free disk space left on all of the local fixed disks. On the Options menu, select Freespace includes 6.x files to view the free space that would exist if the SQL Server 6.x 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.