If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Database Maintenance

Started by StitoTheGreat, 26 Feb 2010 10:18:25 AM

Previous topic - Next topic

StitoTheGreat

Hi Folks,
I've recently inherited a cognos planning 8.3 application and am trying to get up to speed. Our app runs on sql server 2005 and my question is should I schedule regular maintenance jobs on the databases to do stuff like rebuild indexes etc..?

what do other folk on here do regularly?
many thanks.


SomeClown

Biggest things would be making sure the logs don't get full and backup files don't get overly large.  In the Contributor Admin Console, the "backup application" option of the GTP will take a backup but it's an append and not tagged in SQL Server.  Thus, if you are logging, the log file will continue to grow.  And, the backup file could get quite large.  Otherwise, just make sure you have good nightly backups.