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.
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.