How to install SQL 2008 R2 Enterprise Server Software for Cencon 4 Locks?
Updated
Question
How to install SQL 2008 R2 Enterprise Server Software for Cencon 4 Locks?
Answer
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.
Review system performance weekly and adjust accordingly.