Maintenance Manual

70 Enterprise Chat and Email Deployment and Maintenance Guide
Archive Database
 Set the archive database properties as follows:
 Properties of Datafile: Data file size should be set to 5 GB. Autogrowth should be set to 500 MB.
 Transaction log file size should be set to 2 GB. Autogrowth should be set to 2 GB.
Reports Database
 Set the reports database properties as follows:
 Data file size should be set to 20 GB. Autogrowth should be set to 1 GB.
 Transaction log file size should be set to 2 GB. Autogrowth should be set to 1 GB.
Optimal Configuration Settings
The following table describes optimal settings for the databases.
To configure the settings:
1. Run the following query on the ECE databases to set the values for the auto close, auto create statistics, auto
update statistics, auto shrink, torn page detection, and read write properties:
alter database Database_Name
set auto_close on, auto_create_statistics on, auto_update_statistics on,
auto_shrink off, torn_page_detection on, read_write
2. Do the following steps to configure the database auto growth and transaction log auto growth settings.
a. In the Microsoft SQL Server Management Studio, browse to Databases > Database_Name.
Important: The Archive database is available only in installations that use the Standard Edition of
Microsoft SQL.
Important: The Reports database is available only in installations that use the Enterprise Edition
of Microsoft SQL.
Database configuration setting Recommended value
auto_close off
auto_create_statistics on
auto_update_statistics on
auto_shrink off
read_only off
torn_page_detection on
database auto grow on
transaction log auto grow on