Viewing Transaction Logs

  • Hello,

    Does anyone know how I could view a database transaction log?

    Thanks!

    Melanie

  • Log Explorer from Lumigent.

    http://www.lumigent.com

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Syntax

    DBCC LOG ( {dbid|dbname}, [, type = {-1,0,1,2,3,4}])

    Press any key to continue or any other key to exit...


    Press any key to continue or any other key to exit...

  • Hello,

    Thank you for your reply. I actually ran this DBCC command (after doing a helpful search through SQLServerCentral.com) and couldn't quite understand what was returned.

    I have since discovered a product from NetIQ, which I believe is still Lumigent. The product is called Recovery Manager for SQL Server. I am still working with the evaluation version so I haven't gotten the information that I am looking for.

    Thanks again!

    Melanie

  • Recovery Manager for SQL Server looks pretty similar as Log Explorer, but I belive Lumigent and NetIq - different companys...

    I haven't try "Recovery Manager", I've tried Log Explorer, it's could show you transact SQL commands, if you are looking for it...

    Press any key to continue or any other key to exit...


    Press any key to continue or any other key to exit...

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

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