Post reply

Transaction Logs

  • March 5, 2003 at 2:33 pm

    #58767

    I'm trying to view all transaction logs on a database. Does anyone know how? I know how to get the error logs but I would like to view the activity on a particular database.

    Thanks,

    Ayisat

    Ayisat Idris


    Ayisat Idris

  • March 5, 2003 at 2:40 pm

    #450348

    Not sure what you are trying to see. Maybe one of these will be helpful. You can't read the transaction logs as you can an error log without a third party tool.

    dbcc log(model)

    dbcc sqlperf(logspace)


    "Keep Your Stick On the Ice" ..Red Green

  • March 7, 2003 at 10:33 am

    #450569

    jjeffwe is right, to view the transactions in the log you need a third party tool. Try Log Explorer by Lumigent (www.lumigent.com).

    If you want to know, how many log files you have, try sp_helpdb or sp_helpfile.

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

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