same DB for CMS and Auditing ?

server administration XI Server Discussion
1

Hello,

I will be doing a new BO installation, and will use our own database server for the CMS.

I was wondering if anyone has any thoughts on whether I can/should use the same database (and same login credentials) for the Audit database.

Any best practices here? Any reason why I should not do that?

Thanks!

mutsy (BOB member since 2007-11-27)

2

Mutsy,
Your subject has been discussed on BoB, here is a link to one such discussion: Audit database vs. CMS system database

Thanks,
John

jsanzone :us: (BOB member since 2006-09-12)

3

Thanks John,

this thread has many good pointers.
I will definetly be installing the CMS and Audit databases on 2 seperate Oracle databases.

mutsy (BOB member since 2007-11-27)

4

In addition, it depends on how much information you are auditing, the audit database can get filled up very fast. So you better have a good archiving strategy.

substring :us: (BOB member since 2004-01-16)