Post reply

How to view action(insert,update,...) transaction log file on MSSQL 2008

  • February 17, 2012 at 9:49 pm

    #391590

    Hi admin,

    I have transaction log backup on MSSQL 2008, schedule 5 minutes period with *.trn file, but the system data has been changed. I want to view from *.trn file to action(insert,update,delete,...) view

    Can you help ? maybe the script or software

    thanks,

    nhphuong

  • February 17, 2012 at 10:38 pm

    #1448866

    check this article.

    http://www.sqlservercentral.com/articles/Transaction+Log/71415/

    java programming

  • February 18, 2012 at 2:38 am

    #1448878

    The log is not intended to be human readable (and the article only covers reading the currently active log, not a log backup). Log reader tools are around $1000 per license.

    Why do you want to read the log? What do you want out?

    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

Viewing 3 posts - 1 through 2 (of 2 total)

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