Post reply

How to read Log file in Sql Server

  • March 29, 2011 at 2:49 am

    #233927

    Hi everyone,

    Can any one tell me how to read log file (like what transaction happened etc) in SQL SERVER. I have heard that we can do in Oracle using Redo Log file.

    Thanks

  • March 29, 2011 at 2:56 am

    #1304721

    you can use the un-documented DBCC log

    dbcc log (dbname)

    but good luck making sense of it, the structure is not designed to read by people.

    you may be better off getting a log-reader from a third-party like red-gate.

  • March 29, 2011 at 3:53 am

    #1304738

    sue.bandi (3/29/2011)

    Can any one tell me how to read log file (like what transaction happened etc) in SQL SERVER.

    Why? What are you trying to do here? What are you trying to achieve?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 29, 2011 at 3:55 am

    #1304739

    steveb. (3/29/2011)

    you may be better off getting a log-reader from a third-party like red-gate.

    Redgate's one is only for SQL 2000. For 2008, Apex SQL Log ($1000)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 29, 2011 at 4:08 am

    #1304742

    Instead of spending and purchasing 3rd party tool,

    you can use SQL Profiler with selected filters to capture whatever changes is happening in the database.

    since trace file can be huge, so reserving space for these kind of operation is always recommended.

  • March 29, 2011 at 4:26 am

    #1304748

    Can any one tell me how to read log file (like what transaction happened etc) in SQL SERVER.

    if you have litespeed tool and you have upgraded it to 5.0 then Litespeed LogReader is inbuilt and you can use it to read log.

    ----------
    Ashish

  • March 29, 2011 at 4:27 am

    #1304749

    chetanr.jain (3/29/2011)

    Instead of spending and purchasing 3rd party tool,

    you can use SQL Profiler with selected filters to capture whatever changes is happening in the database.

    since trace file can be huge, so reserving space for these kind of operation is always recommended.

    that is useful if you have setup the trace before the fact... otherwise it would be to late to do anything afterwards

  • March 29, 2011 at 11:39 am

    #1305053

    THANK YOU

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply