Cisco Cisco IP Contact Center Release 4.6.1 Installation Guide
Note: The maximum size must not exceed 80% of the total disk space available on the system.
Step 11
Click the Transaction Log tab
Step 12
Set the Initial Size to 500 MB.
Step 13
Insure both Automatically grow file and Unrestricted file growth are selected.
Step 14
Click OK.
Step 15
You must now configure your database.
Step 16
Expand the Databases folder clicking on the + icon.
Step 17
Right-click the just created ICM database.
Step 18
Select Properties....
Step 19
Select the Options tab and set the following values:
•
ANSI NULL default: No
•
Recursive triggers: No
•
Auto update statistics: Yes
•
Torn page detection: Yes
•
Auto close: No
•
Auto shrink: No
•
Auto create statistics: Yes
•
Auto create statistics: Yes
•
Use quoted identifier: No
•
Leave all other parameters at their default values.
Step 20
If changes have been made, the MSSQLSERVER Service may need to be cycled.
Step 21
Close SQL Enterprise Manager.
How to set the Logger or HDS database data file size for maximum growth using SQL Enterprise Manager
Step 1
Launch Start > Programs > Microsoft SQL Server > Enterprise Manager.
Step 2
Expand Microsoft SQL Servers by clicking the + icon next to it.
Step 3
Expand SQL Server Group by clicking the + icon next to it.
Upgrade Guide Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.0(0)
146
Chapter 19: - Database Tasks