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 |
|
mnewbould
Starting Member
1 Post |
 Posted - 2002-09-20 : 09:46:36
|
| Has anyone architected a solution using Lumigent Log Explorer's LogView combined with Transaction Log backups to audit and provide rollback functionality for each transaction?I'm curious as to whether a daily backup or using the online log would provide a day by day audit trail better?Thanks all-Max |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-20 : 09:53:19
|
If you can take the data from Log Explorer and output it, then you might be able to construct an auditing system with it. But generally speaking the transaction log should NOT be the basis for an auditing system. Unless you maintain log backup files forever, you can't tell what an audited value was from a year ago, for example. Log Explorer is more intended for data recovery that cannot be accomplished by restoring backups. Also, depending on what you need to audit, and what recovery model used for the database, the transaction log won't have all of the auditable information either.Search SQL Team and the SQL Team forums for "audit", there's been some discussion on this. *SPOILER ALERT* - Also keep an eye out for an article from graz  on auditing.<edit> Lockwood Tech and Red Gate have auditing products that might be better suited to your needs.</edit>Edited by - robvolk on 09/20/2002 09:55:12 |
 |
|
|
|
|
|
Lumigent Log View Tool