Cisco Cisco IPCC Web Option Installation Guide

Page of 180
   
Chapter 7      ICM 4.6.2 to ICM 5.0 Upgrade SQL Server Installation and Upgrade
Upgrading MS SQL Server 7.0 to MS SQL Server 2000
7-6
Cisco ICM Software Upgrade Migration Guide, Release 6.0(0)
d.
Select the server.
e.
Add the data devices by highlighting the disk drive in the device field.
f.
Enter the size of the database device.
g.
Add the appropriate Log Devices. The size of this device typically should not 
be larger than 500 MB for most ICM installations.
h.
Enable partitioning if applicable.
i.
Click Database > Create
Note
The amount of time necessary to create the database is dependant on the 
database size.
Once the database is created, configure SQL Server 2000 by following steps 1-4 
(inclusive) of 
Upgrading MS SQL Server 7.0 to MS SQL Server 2000 
The SQL Server 7.0 to SQL Server 2000 upgrade is straightforward. Before 
running SQL Server 2000 setup, however, some Microsoft fixes have to 
accomplished, otherwise, the upgrade may fail. Two bugs in the Microsoft 
knowledge database may cause an error during upgrading from SQL 7.0 to SQL 
2000.
Q300676 fixes a race condition when running Message.sql.
Q285100 fixes connectivity problems over the SQL Server Shared Network 
Library component.
These bug fixes can be downloaded from Microsoft web site. To apply the bug fix, 
the files on the SQL Server 2000 installation CD have to be copied to a disk. This 
is because the bug fix requires replacing a few files on the CD. It is not convenient, 
but Microsoft has confirmed that it is the only way to apply in the bug fix.
Refer to 
upgrade procedure.