Post reply

Transaction Log for Insert/Delete/Update

  • August 10, 2010 at 1:47 am

    #224490

    Hi,

    Can anyone pls tell me how do i get the transaction log from SQL Server. [insertions/updations/deletions made into the tables] or how do i open .trn file (Transaction log file)

    I am using SQL Server 2008

    Thanks

    Deepan

  • August 10, 2010 at 2:40 am

    #1204558

    select top 1 * from fn_dblog(null, null) ?

  • August 10, 2010 at 4:40 am

    #1204618

    The transaction log is not intended to be human-readable. What are you trying to do that you want to read the log?

    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

  • August 10, 2010 at 4:52 am

    #1204631

    not exactly...

    Everyday I am taking full backup of my database. Now i want to get the transaction level changes made into the database. i.e.,

    i). records inserted/deleted,

    ii). tables/procedures/functions/triggers created/modified/deleted

    since last week

  • August 10, 2010 at 5:12 am

    #1204648

    For what purpose?

    Auditing? (consider DDL and DML triggers)

    To apply the changes to another server? (consider log shipping or replication)

    Something else?

    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 5 posts - 1 through 4 (of 4 total)

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