Post reply

To see the transaction LOG(.ldf file of DB)

  • December 1, 2008 at 9:16 pm

    #198422

    Dear All

    Is it possible to see the transaction LOG(.ldf file of DB).If yes then how?

    Thanks

  • December 2, 2008 at 1:18 am

    #906065

    See its contents?

    Sure.

    SELECT * FROM fn_dblog(null, null)

    It's not exactly what I'd call human readable though.

    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

  • December 2, 2008 at 1:39 am

    #906072

    Thanx GilaM..

    But please tell me wat is fn_dblog?

    Thanks

  • December 2, 2008 at 1:45 am

    #906074

    It's a built-in function that returns a resultset of the records currently in the transaction 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

  • December 2, 2008 at 1:56 am

    #906077

    Thanx GilaMonster....Thanx

    Thanks

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

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