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 logfiles in SQL have mdf extention


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