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.
| Author |
Topic |
|
yshwntsingh
Starting Member
1 Post |
 Posted - 2012-08-02 : 07:13:56
|
| How to read transaction logsyashwant 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-winAlso, 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/ |
 |
|
|
|
|
|
How to read transaction logs