Recommendations for Symantec Control Compliance Suite (CCS) v11.0 database creation
| Article:TECH195669 | | | Created: 2012-08-27 | | | Updated: 2012-08-27 | | | Article URL http://www.symantec.com/docs/TECH195669 |
Problem
A Control Compliance Suite (CCS) user 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 dos and don’ts for manual database creation.
When a database is created by the installer the database is a copy of the model database with some exceptions.
Environment
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.
o CCS 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. No SYSADMIN privilege is required once the databases are created.
· 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
o Number of assets in the system
o Frequency of evaluation of standards against assets
o Evaluation results
o Purge criteria
Indicative scaling guidelines for the CCS databases can be found in the Online Help.
Best practices around database growth settings can be found at
· If the user wishes to have multiple database files, it is recommended that addition of the same is done post the installation of the product.
Solution
Post installation properties of CSM_DB (Production Database)
· Recovery model of CSM_DB is set to Full.
· CSM_DB has two file groups
o PRIMARY (Default)
§ Autogrowth – 1 MB, unrestricted
o CCS_QUERIES – Used to store Queries data.
§ Initial Size – 50 MB
§ Autogrowth – 10%, unrestricted
Post installation properties of CSM_Reports (Reporting Database)
Following are the database properties post installation:
· Recovery model of CSM_DB is explicitly set to Simple.
· CSM_Reports has two file groups
o PRIMARY (Default)
§ Autogrowth – 1 MB, unrestricted
o CSM_Reports_EvidenceStorage_%DATE% – Used to store Evidence data.
§ Initial Size – 100 MB
§ Autogrowth – 100%, unrestricted
|
|
Article URL http://www.symantec.com/docs/TECH195669
Terms of use for this information are found in Legal Notices
Thank you.