Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-19 : 07:07:31
|
| pankaj writes "which is a better practice ..... use the same database server for log tables or use diff one .. can i put a trigger to insert records in tables on diff database ..and what r the other better options available for audinting ..thx in advance" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-19 : 07:44:45
|
| Whwn I consider anything in a separate database I ask myself:1) The backups will not be exactly scynchronised, does that matter?2) The Triggers / SProcs will reference another database by name - will that cause a problem during rollout from Dev to Test, or Test to Production?However, Audit tables are often huge, compared to the original database, and having them in a separate database can make the housekeeping, backup arrangements, optimisation, and so on, easier. Cleardown of stale audit entries can become a massive task, and having that run in a separate database can help throughput at the time it is needed.Kristen |
 |
|
|
|
|
|
Best Auditing Practice