Cisco Cisco IPCC Web Option Installation Guide
Step 4
Click on the Transaction Log tab. Set the following parameters:
•
Space Allocated must be at least 400 MB.
•
Set Automatically grow files.
•
Set Unrestricted file growth.
Step 5
Click OK.
Step 6
Close SQL Enterprise Manager.
For Production Systems
Step 1
Select Start > Programs > Microsoft SQL Server > Enterprise Manager.
Step 2
Expand Databases by clicking on the + icon, right-click on the tempdb database, and select
Properties.
Properties.
Step 3
Click on the Data Files tab. Set the following parameters:
•
Space Allocated must be at least 100 MB. The allocated space may be significantly larger
after data migration. If so, shrink the file down to 100 MB.
after data migration. If so, shrink the file down to 100 MB.
•
Set Automatically grow files.
•
Set Maximum file size to 500 MB.
Step 4
Click on the Transaction Log tab. Set the following parameters:
•
Space Allocated must be at least 50 MB.
•
Disable Automatically grow files.
Step 5
Click OK.
Step 6
Close SQL Enterprise Manager.
Upgrade Guide Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.0(0)
149
Chapter 19: Database Tasks
How to Set the tempdb Database Size