Post reply

view transaction log time stamp

  • January 15, 2013 at 12:29 pm

    #272774

    I use DBCC LOG(mydbname,4) to view log info.

    But I don't see what is the date time stamp for each record.

    Is there any place I can find it?

    Thanks

  • January 15, 2013 at 12:40 pm

    #1577479

    The Checkpoint begin has a time, so does the begin transaction log record. The transaction log is not an audit log, the log records don't all need to have datetime stamps.

    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

  • January 15, 2013 at 12:49 pm

    #1577485

    GilaMonster (1/15/2013)

    The Checkpoint begin has a time, so does the begin transaction log record. The transaction log is not an audit log, the log records don't all need to have datetime stamps.

    Thanks, so which column tells the time for checkpoint begin and begin transaction log record?

  • January 15, 2013 at 1:23 pm

    #1577508

    They're called "Checkpoint Begin" and "Begin Time", not in the old DBCC Log though, in the undocumented function fn_dblog

    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

  • January 15, 2013 at 1:25 pm

    #1577509

    Thanks, will give it a try

Viewing 5 posts - 1 through 5 (of 5 total)

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