A Control Compliance Suite (CCS) user installing the product can choose to create the CSM_DB and the CSM_Reports databases manually rather than let the product create the databases.
This document will cover certain facts and guidelines for manual database creation.When a database is created by the installer the database is a copy of the model database with some exceptions.
The following are the considerations for manual database creation:
·Support for custom database names does not exist.
·The default file group of the CCS databases must be PRIMARY.
oCCS continues to use the PRIMARY file group even if the default file group on the CCS databases is set to a user defined file group.
·For manually created databases, the Application Server Service account must have the DBO privilege on CSM_DB and CSM_Reports. SYSADMIN privilege is not required once the databases are created - DBO is sufficient.
·Initial database size of 1024 MB is recommended for both CSM_DB and CSM_Reports.
·The growth of the databases is based on the following factors
oNumber of assets in the system
oFrequency of evaluation of standards against assets
Indicative scaling guidelines for the CCS databases can be found in the Online Help.