January 5, 2010 at 11:20 pm
As developers, we tend to think of a log as some container that records some non-critical detail about an event that happened in the past. The SQL Server Transaction Log is certainly quite a different animal in that regard. To think of it as a "Log" causes much of the confusion and disrespect I see around the Biz. If it were called the transaction Journal, more people might grasp the difference and stop asking me "Why can't we just truncate the log data dba dude". And I get drawn in to some boring argument where I have to describehow how the Transaction "JOURNAL" BEHAVES.
Just a raunt
.
April 5, 2010 at 9:02 am
BSavoie (1/5/2010)
As developers, we tend to think of a log as some container that records some non-critical detail about an event that happened in the past.
That's one of the many differences in between being a developer and being a DBA; don't you think so?
The term "log" as applies to SQL Server Transaction Log has being in the industry since a few split seconds after the big bang, I remember the term from Total, a network based dbms very popular during the last century.
By the way... saying that a "log is some container that records some non-critical detail" is plain wrong. Usually general information and critical messages are logged on that kind of "logs".
Just my two cents.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 5, 2010 at 10:32 am
BSavoie (1/5/2010)
If it were called the Transaction Journal...
...I would expect to see it published monthly 😀
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 5, 2010 at 11:26 am
Paul White NZ (4/5/2010)
BSavoie (1/5/2010)
If it were called the Transaction Journal......I would expect to see it published monthly 😀
you made my day! 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply