How to install SQL 2008 R2 Enterprise Server Software for Cencon 4 Locks?
Updated
How to install SQL 2008 R2 Enterprise Server Software for Cencon 4 Locks?
Choose between case-sensitive and (default) non-case-sensitive collation for the SQL 2008 R2 database Cencon is to use.
Transaction log backup path must be set to allow point-in-time recovery.
Size the transaction logs to start with a file size of at least 25% of the database size.
Prior to performing an update of a previous Cencon database using the CenconDBSetupUtility, first increase the size of the transaction logs and the database file size by at least 50% for best performance.
Monitor the log transaction rates weekly and change size up or down depending on how quickly the logs are getting filled.
Note: Review system performance weekly and adjust accordingly.