No, the tables have to be created in the same database. You can adjust how long the data stays in there (I can't remeber off the top of my head how this is done but I remember seeing it somewhere.) another option is to have a process that offloads that data into another database so your ct tables are really just a temporary storage place. If you offload the data prior to the full backups, you would keep the size of the full backup low.