Re: read trans log

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 19:44:12 +0530

Hi ,

You can read the log file only if your database is set in "FULL" recovery
model. If it is FULL then as Vyas mentioned you can use
Log explorer from lumigent technologies.

http://www.lumigent.com/Downloads/

Thanks
Hari
MCDBA

"sudha" <anonymous@discussions.microsoft.com> wrote in message
news:DBABBE4E-CEAD-4006-AF23-311AAAA9CF9E@microsoft.com...
> hi all
> how do i read a transaction log file? i need to detect which process
cleared up the data in some tables from production.
>
> thanks

Relevant Pages

  • Re: SQL Database Purge
    ... Are you performing log backups regularly? ... set the database to simple recovery mode. ... > recovery model is set to FULL and the log file is nearly 66 GB. ...
    (microsoft.public.sqlserver.server)
  • Re: optimum log file size
    ... Fixing of Transaction log file based up on the amount of bulk transaction ... CUrrent log growth will be because of FULL recovery mode. ... If you do not require a point in time recovery or if your database ...
    (microsoft.public.sqlserver.clients)
  • Re: How to attach db with missing log file?
    ... Start SQL Service ... Database fake will appear as suspect in EM ... I support PASS - the definitive, ... > allowing me to get past the missing log file, ...
    (microsoft.public.sqlserver.server)
  • RE: Shrink File?
    ... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
    (microsoft.public.sqlserver.setup)
  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)