Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

Planning application SQL logfiles stored together with datafiles


#1

When you create in Contributor Administration a new application in SQL server, You can only provide a data directory but not a log directory. Therefore the data and log files are created in the same directory. You can change this by editing the file epEAdminSQL7Resources.xml located in <installation directory>\c8\bin.

Example:
The SQL server log file directory is F:\SQL\Logs

In line 6 you find the following line for the log file location

LOG ON ( NAME = [%1_log], FILENAME = N'%2%1_log.ldf', SIZE = 10MB, FILEGROWTH = 10% )

change this into

LOG ON ( NAME = [%1_log], FILENAME = N'F:\SQL\Logs\%1_log.ldf', SIZE = 10MB, FILEGROWTH = 10% )

Save file and restart Cognos services.

Tip: you can change here also the initial size of the database and the file growth behavior

www.cogknowhow.com