Reset Cognos Namespace tables

[jacobsk]

What do i need to do to reset the tables to the original contents of the cognos namespace without reinstalling the product. is there a SQL available?

[cogadmin]

You can stop Cognos service first, then drop and recreate content store database, restart Cognos service.

[sir_jeroen]

check the following location for a cleanup script: <c8 install>configuration/schema/<db type>/content.
There should be some scripts for cleaning your cstore...