Home Knowledge Articles IBM Cognos 8 Planning Planning application logfiles in SQL have mdf extention
Follow us on Twitter


Countries

50.1%United States United States
7.6%India India
7%United Kingdom United Kingdom
5.1%Australia Australia
4.8%Canada Canada

Visitors

Today: 32
Yesterday: 573
This Week: 32
Last Week: 3348
This Month: 9417
Last Month: 15365
Total: 383504


Planning application logfiles in SQL have mdf extention Print E-mail
(0 votes, average 0 out of 5)

When you create an application in Cognos Planning contributor, the log file of this SQL database is mdf instead of ldf.

You can change this by editing the epEAdminSQL7Resources.xml located in the <installation directory>\c8\bin

search for string (line 6) 

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

Change mdf to ldf

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

save file and restart Cognos services to let the change take effect

www.cogknowhow.com

Comments

Please login to post comments or replies.
 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?