I have a project server 2003 instance running. I backup the SQL server database every night. I have noticed that project server also uses SQL server analysis services as well and has a cube. Does this cube need to be backed up or can it be re-created from the project server database?
If it does need to be backed up, how can this be automated?