Cisco Cisco IP Contact Center Release 4.6.2 Installation Guide

Enter the required database connection information:

•

Make sure that the current system name is selected.

•

Select Use Standard Security.

•

Make sure the login id is sa or equivalent.

•

Supply a password if required.

Click Connect.

The Microsoft ISQL_w application opens. Make sure the selected database in the DB: drop
down is master.

Select File > Open from the Microsoft ISQL/w menu.

Enter EXECUTE sp_helpdb into the Query window and execute the script by clicking the green
arrow or by selecting Query > Execute from the Microsoft ISQL/w menu.

Note the value located in the db_size column for the ICM database.

Exit the Microsoft ISQL/w program.

How to Set the tempdb Database Size

The size and configuration of the tempdb database during data migration differs for the parameters
used in a production system. This section describes how to set tempdb for each case.

For Data Migration

Select Start > Programs > Microsoft SQL Server > Enterprise Manager.

Expand Databases by clicking on the + icon, right-click on the tempdb database, and select
Properties.

Click on the Data Files tab. Set the following parameters:

•

Space Allocated must be at least 1400 MB.

•

Set Automatically grow files.

•

Set Unrestricted file growth.

Upgrade Guide Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.0(0)