Re: Transaction log and trigger

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 07:41:16 +0530

Hi,

You can recover the database till May 01st 09:59 AM provided your database
is set to FULL recovery model and you have
all the transaction log backups.

Recreate the trigger and apply the changes on the table from the transaction
log after the trigger is deleted(from may 1st 10.01 am?

Did you meant , after creating the trigger , if you apply the transaction
logs will the auditing be enabled for transactions after May 01 10:01 AM?

This cant be done by just applying the transation log backups. Transaction
log backups only contains the logs of the transaction you had.
As well as your database should be in NO Recovery mode/ readonly till you
restore all transaction log files. So you cant even create the
trigger in between.

Thanks
Hari
MCDBA

"csar" <anonymous@discussions.microsoft.com> wrote in message
news:CDF17E13-4BC0-4904-A349-4C9AD8B6C12B@microsoft.com...
> Hi
> I have a problem with one of a trigger getting deleted in production
and the audit for the table is not present for the past month(from may 1st
10 am). Is it possible for me to restore the database from until the time
the trigger was active (till may 1st 9.59 am) and recreate the trigger and
apply the changes on the table from the transaction log after the trigger is
deleted(from may 1st 10.01 am?
>
> Thanks
> csar

Relevant Pages

  • Re: huge log file when inserting data
    ... Nothing else is running on the database. ... No trigger. ... The insert is in a transaction and it is committed. ... >space requirements. ...
    (microsoft.public.sqlserver.server)
  • Re: Auditing changes made to table design (syscolumns table)
    ... With out using profiler the only way I know of is to get this info from the ... Keep in mind I know the database and the tables I would ... I attempted to write a trigger to log when a change was made to the ... > certain criteria against every transaction. ...
    (microsoft.public.sqlserver.security)
  • Enable/Disable a database trigger when running a dbunit test
    ... The dabase id's in this database are generated by a trigger. ... the transaction is commited after enabling the trigger: ... data in the database is lost, the testdata is now in place. ...
    (comp.lang.java.help)
  • Re: Enable/Disable a database trigger when running a dbunit test
    ... The dabase id's in this database are generated by a trigger. ... that the transaction is commited after enabling the trigger: ... rollback transaction ...
    (comp.lang.java.help)
  • Re: Transaction log and trigger
    ... You would have to "recover" the database to re-create the trigger. ... and then apply transaction log which was backed up for the next hour(by this ...
    (microsoft.public.sqlserver.server)