Posted on 2007-10-15
Medium Priority
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
  • 2
LVL 75

Accepted Solution

Aneesh Retnakaran earned 1000 total points
ID: 20083191
>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 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 20083195
>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 143

Expert Comment

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

864 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