Re: Transaction Log

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 07/25/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Thu, 25 Jul 2002 13:35:58 -0400

Yes that is correct. The tool from Lumigent is the only one I know of that
uses the log in this fashion. He was looking for some way to track changes.
The logs are usually truncated or not necessarily kept for that long of a
period so if you what a history of who did what and when, triggers is
generally the way to do it. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"Steve Thompson" <stevethompson@nomail.please> wrote in message
news:e$oG25$MCHA.2420@tkmsftngp11...
> Looks like this one is based on table level triggers and not the
transaction
> log?
>
> Steve
> "Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
> news:ebFO0C#MCHA.2192@tkmsftngp11...
> > While the tool from lumigent is great for finding what happened etc.  it
> may
> > not be a good long term solution to your issue.  What your after is
really
> > an audit trail.  There are several 3rd party tools to do this. One that
I
> > know of is at www.redmatrix.com
> >
> >
> > --
> > Andrew J. Kelly   SQL MVP
> > Targitinteractive, Inc.
> >
> >
> >
> > "Sean" <salford@eca-eaec.com> wrote in message
> > news:17cb01c233d8$029a14c0$2ae2c90a@phx.gbl...
> > > Problem
> > >
> > > Our IT director for auditing purposes (Thanks Enron!!!)
> > > wants to log user interaction for all database
> > > transactions.  For example, if an H.R. user updates the
> > > salary attribute for an employee in the employee's table
> > > we need to be able to determine the following information.
> > >
> > > Date & Time of transaction
> > > User who initiated the transaction
> > > Before & After values of the transaction
> > > Workstation ID where the transaction was initiated.
> > >
> > > Questions
> > >
> > > 1. I understand that SQL Server maintains a transaction
> > > log for each database for restoration purposes.  Can this
> > > transaction log be used to meet our auditing needs?  If so
> > > how does one view the transaction log?  Is the database
> > > transaction log locked while the database is online?
> > >
> > > If the transaction log cannot be used for auditing
> > > purposes, what are some best practices to achieve these
> > > requirements?
> > >
> > > Thanks,
> > > Sean
> >
> >
>
>

Relevant Pages

  • Re: Transaction log problems
    ... IF you have to shrink a database or file it ... sure that you get that database backup on tape or to another machine. ... > We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... > One of the databases has recently begun showing large growth of the> transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)
  • RE: Backup in maintenance plan
    ... I selected "Back up the transaction log of the database as part of the ... To ensure an efficient and effective backup and recovery strategy for your ... The transaction log should not be backed up if the truncate log on ...
    (microsoft.public.sqlserver.programming)
  • Re: Restoring from non-truncated transaction log
    ... The transaction log is there to support transactional consistency as well ... as supporting "incremental" backup. ... A database backup contains both data pages as well as the necessary log records (from the ... When your restore a database backup, ...
    (microsoft.public.sqlserver.server)
  • Re: Large Transaction Log Backup after Database Backup
    ... script and see for yourself that the database backup doesn't truncate the ... ALTER DATABASE steve SET RECOVERY FULL ... But my understanding was that the transaction log was> truncated after a full database backup. ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction Log Size
    ... Backup database does not empty the transaction log files. ... How to Shrink the SQL Server 7.0 Transaction Log ...
    (microsoft.public.sqlserver.server)
Loading