Cisco Cisco IPCC Web Option Installation Guide
Chapter 12 ICM 4.6.2 or ICM 5.0(0) to ICM/IP Contact Center Enterprise Edition, Release 6.0(0) SQL Server
Pre-Upgrade database planning
12-8
Cisco ICM Software Upgrade Migration Guide, Release 6.0(0)
Recursive triggers: No
Auto update statistics: Yes
Torn page detection: Yes
Auto close: No
Auto shrink: No
Auto create statistics: Yes
Use quoted identifier: No
All other parameters should be left as default
Step 3
If changes are needed, the MSSQLSERVER Service may need to be cycled.
Step 4
Close SQL Enterprise Manager.
Pre-Upgrade database planning
To upgrade from SQL Server 7.0 to SQL Server 2000, there is not much planning
to do because there is no data transfer of during the upgrade.
to do because there is no data transfer of during the upgrade.
Upgrading MS SQL Server 7.0 to MS SQL Server 2000
The SQL Server 7.0 to SQL Server 2000 upgrade is used during a common ground
upgrade migration.
upgrade migration.
How to upgrade SQL Server 7.0 to SQL Server 2000
Step 1
Copy the SQL Server 2000 Installation CD to a disk.
Step 2
Using the MS SQL Backup/Restore procedure, back up all databases to be
upgraded.
upgraded.
Note
Backing up the cust_awdb is not required.