System-specific configuration

The server configuration file contains information defining application databases. This information includes the sizes of the databases and the locations of each database’s data files and log files.

Note: Different systems may have different configuration files. These files usually reside in the config directory. Ensure that you are selecting the right file for the installation tool.

The server configuration file is a Microsoft SQL script file that is written using Microsoft SQL 92 with either Transact-SQL (Sybase) or T-SQL (Microsoft) extensions applied.

The following is a configuration file example:

--=========================================================================

-- Historical_install.cfg : Configuration file used for Historical

-- installation. It defines baseline required Historical - Databases.

--======================================================================

-- accum Database definition.

--======================================================================

--===================================================================

--Drop existing database

--===================================================================

drop database accum

go

--===================================================================

--Create new database

--===================================================================

create database accum

on primary

(name = accum_Data,

filename = 'C:\XIS DATA\XISDisk1\MSSQL\accum_Data.mdf',

size = 31MB,

maxsize = 31MB,

filegrowth = 0)

log on

(name = accum_Log,

filename = 'C:\XIS DATA\XISDisk2\MSSQL\accum_Log.ldf',

size = 3MB,

maxsize = 3MB,

filegrowth = 0)

go

exec sp_dboption

'accum',

'autoclose',

'false'

go

exec sp_dboption

'accum',

'select into/bulkcopy',

'false'

go

exec sp_dboption

'accum',

'trunc. log on chkpt.',

'true'

go

--=======================================================================

-- xosapp Database definition.

--=======================================================================

--====================================================================

-- Drop existing database

--====================================================================

drop database xosapp

go

======================================================================

-- Create new database

--====================================================================

create database xosapp

on primary

(name = xosapp_Data,

filename = 'C:\XIS DATA\XISDisk1\MSSQL\xosapp_Data.mdf',

size = 7MB,

maxsize = 7MB,

filegrowth = 0)

log on

(name = xosapp_Log,

filename = 'C:\XIS DATA\XISDisk2\MSSQL\xosapp_Log.ldf',

size = 2MB,

maxsize = 2MB,

filegrowth = 0)

go

exec sp_dboption

'xosapp',

'autoclose',

'false'

go

exec sp_dboption

'xosapp',

'select into/bulkcopy',

'false'

go

exec sp_dboption

'xosapp',

'trunc.

log on chkpt.'

'true'

go

--======================================================================

-- CommStats Database definition.

--======================================================================

--===================================================================

-- Drop existing database

--===================================================================

drop database CommStats

go

=====================================================================

-- Create new database

=====================================================================

create database CommStats

on primary

(name = CommStats_Data,

filename = 'C:\XIS DATA\XISDisk1\MSSQL\CommStats_Data.mdf',

size = 512MB,

maxsize = 512MB,

filegrowth = 0)

log on

(name = CommStats_Log,

filename = 'C:\XIS DATA\XISDisk2\MSSQL\CommStats_Log.ldf',

size = 100MB,

maxsize = 100MB,

filegrowth = 0)

go

exec sp_dboption

'CommStats',

'autoclose',

'false'

go

exec sp_dboption

'CommStats',

'select into/bulkcopy',

'false'

go

exec sp_dboption

'CommStats',

'trunc. log on chkpt.',

'true'

go

--======================================================================

-- event Database definition

--======================================================================

--===================================================================

-- Drop existing database

--===================================================================

drop database event

go

=====================================================================

-- Create new database

=====================================================================

create database event

on primary

(name = event_Data,

filename = 'C:\XIS DATA\XISDisk1\MSSQL\event_Data.mdf',

size = 512MB,

maxsize = 512MB,

filegrowth = 0)

log on

(name = event_Log,

filename = 'C:\XIS DATA\XISDisk2\MSSQL\event_Log.ldf',

size = 52MB,

maxsize = 52MB,

filegrowth = 0)

go

exec sp_dboption

'event',

'autoclose',

'false'

go

exec

sp_dboption

'event',

'select into/bulkcopy',

'false'

go

exec sp_dboption

'event',

'trunc. log on chkpt.',

'true'

go

--======================================================================

-- timeline Database definition.

--======================================================================

--===================================================================

-- Drop existing database

--===================================================================

drop database timeline

go

--===================================================================

-- Create new database

--===================================================================

create database timeline

on primary

(name = timeline_Data1,

filename = 'C:\SQL Data\SQLDisk3\MSSQL\timeline_Data.mdf',

size = 8GB,

maxsize = 8GB,

filegrowth = 0),

(name = timeline_Data2,

filename = 'C:\XIS DATA\XISDisk4\MSSQL\timeline_Data.mdf',

size = 8GB,

maxsize = 8GB,

filegrowth = 0)

log on

(name = timeline_Log,

filename = 'C:\XIS DATA\XISDisk2\MSSQL\timeline_Log.ldf',

size = 2GB,

maxsize = 2GB,

filegrowth = 0)

go

exec sp_dboption

'timeline',

'autoclose',

'false'

go

exec sp_dboption

'timeline',

'select into/bulkcopy',

'false'

go

exec sp_dboption

'timeline',

'trunc. log on chkpt.',

'true'

go

--========================================================================