Posted on 2007-10-15
Last Modified: 2010-03-19
Hello Experts,

Need some explanation...reading into MS SQL and I know i am getting ahead of myself here, but I am trying to figure out this "transaction log".  So here it goes...if I make a change on a record, would it be included on the log?  If so, can the log be viewed?  And how can this be done?  Is it a matter of doing a "SELECT" ...?  What does the log track?  How does one proceed on restoring a "transaction log"?

As always, thank you for your time on this matter.
Question by:coperator
    LVL 75

    Accepted Solution

    >if I make a change on a record, would it be included on the log?
    Yes, all the Operations will be performed in the log file first, then it will update the datafile
    > If so, can the log be viewed?
    U need to use third party softwares like  red-gates Log rescue  or Lumigent Log explorer

    > Is it a matter of doing a "SELECT" ...?  
    This is a data retrieval operation so, there wont be any entry for this in the log

    > How does one proceed on restoring a "transaction log"?
    If you check Books Online for the word 'Restore' you can see few examples.
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    >if I make a change on a record, would it be included on the log?  
    yes. both the "old" and the "new" values are saved in the log

    > If so, can the log be viewed?  
    with sql 2000 and earlier, there are only commerical toos that can read an "OFFLINE" log file: lumigent logexplorer to name just one.
    with sql 2005, I think there is new stuff:
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    sorry, that last link is the wrong one... and I don't find the correct one .....

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now