Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to read transaction logs

Author  Topic 

yshwntsingh
Starting Member

1 Post

Posted - 2012-08-02 : 07:13:56
How to read transaction logs

yashwant kr singh

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-08-02 : 08:18:28
"Although you might assume that reading the transaction log directly would be interesting or even useful, it’s usually just too much information." That, according to Kalen Delany in her book "Microsoft SQL Server 2008 Internals".

If you describe what you are trying to get, some of the people on this forum may be able to offer easier/simpler ways to accomplish that.

This page lists two third party tools. It is from 2006, don't know if they are still in business.
http://www.sqlmag.com/article/tsql3/when-sql-server-tool-vendors-compete-dbas-win

Also, these articles might help:

http://www.mssqlcity.com/Articles/KnowHow/ViewLog.htm
(The DBCC command to do this is an undocumented feature)

http://www.sqlservercentral.com/articles/Transaction+Logs/71415/
Go to Top of Page
   

- Advertisement -