Creating Databases

If you plan to use “Custom” mode in Fabasoft Folio Setup, databases can be specified manually.

For each Fabasoft Folio COO Service an own database has to be created. By default, one Fabasoft Folio COO Service named “COOSVC1” is created.

Create a database with following values:

• Database name: COOSVC1
• Initial size of database file: 200 MB
• Initial size of transaction log: 50 MB

Note:

• The database option READ_COMMITTED_SNAPSHOT must be enabled (see
  https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=sql-server-ver16#read_committed_snapshot--on--off-: new window).
• The database and the transaction log should be placed on two different physical disks for performance reasons.
• Autogrowth should be enabled.