Transaction Logs

Discussion in 'Databases' started by kingwoodbudo, Jan 20, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. kingwoodbudo

    kingwoodbudo

    I did a search on Transaction Logs but didn't see anything, so I apologize in advance if this question has been answered already.

    I wanted to know how I can see the transaction logs for my database.

    Thanks.
     
    kingwoodbudo, Jan 20, 2012
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    what do you mean by seeing the transaction log? SQL Transaction is a binary file and is not meant for viewing directly.
     
    Bruce, Jan 20, 2012
    #2
  3. kingwoodbudo

    kingwoodbudo

    Thanks Bruce. I'm a developer and not very familiar with SQL Server tools. I wasn't sure if there was a log of the transactions that have occurred over a period of time. For instance, I'd like to see all the deletes that occurred over the past couple of days, is there a way to do that?

    Thanks for you help.
     
    kingwoodbudo, Jan 20, 2012
    #3
  4. dmitri

    dmitri DiscountASP.NET Staff

    Unfortunately, there is no way to see these. The databases run in simple recovery mode, therefore the transaction logs are being truncated automatically every time the checkpoint occurs (approximately every 10-15 minutes). Moreover, transaction logs are placed on separate RAID and cannot be accessed. Finally, as Bruce noted, t-logs are binary files that cannot be read directly unless you have special third-party tools.
     
    dmitri, Jan 22, 2012
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page