Reading SQL Server's Transaction Log

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kraig Kerr » Reading SQL Server's Transaction Log

44 posts, Page 2 of 5

««1 2 3 4 5 »»»

Reading SQL Server's Transaction Log

Rate Topic

Display Mode

Topic Options

Author

Message

Phil Brammer

Posted Monday, November 22, 2010 8:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:56 AM
Points: 109, Visits: 564

DBCC PAGE is undocumented as well. Use at your own risk.

Post #1024387

dma-669038

Posted Monday, November 22, 2010 8:29 AM

Old Hand

Group: General Forum Members
Last Login: Monday, November 12, 2012 6:46 AM
Points: 312, Visits: 1,024

Yes that was my thought too, lot of very detailed research and very well written, but what practical use would you put this to?

Post #1024394

rbaskett

Posted Monday, November 22, 2010 11:03 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, June 14, 2012 4:51 PM
Points: 14, Visits: 53

SRD?

Post #1024524

Kraig Kerr

Posted Monday, November 22, 2010 11:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:58 AM
Points: 8, Visits: 222

Looks like TDWI took down that link. Here is another that points to the same article. http://findarticles.com/p/articles/mi_m0EIN/is_2000_Nov_8/ai_66696495/

The current flavor of this works with SQL 2008, but with minor changes will work with SQL 2005. I also have a version for SQL 2000. I should have specified this in the article, thanks for the catch.

Post #1024551

Kraig Kerr

Posted Monday, November 22, 2010 11:44 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:58 AM
Points: 8, Visits: 222

Systems Research & Development (SRD) founded by Jeff Jonas.

Post #1024552

rbaskett

Posted Monday, November 22, 2010 11:46 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, June 14, 2012 4:51 PM
Points: 14, Visits: 53

Thought so. They still doing data warehousing or just the identity stuff?

Post #1024558

Kraig Kerr

Posted Monday, November 22, 2010 11:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:58 AM
Points: 8, Visits: 222

Not sure. It was folded into IBM and I haven't seen any other information about their log reading tech.

Post #1024564

g.korot

Posted Monday, November 22, 2010 12:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 28, 2013 12:56 AM
Points: 5, Visits: 151

Hi Kraig

Thank you very much for very useful article regarding transaction log reading. I have a question about update and delete commands - how we can handle these operations?

Thanks

Post #1024574

Mike C

Posted Monday, November 22, 2010 1:06 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276, Visits: 1,112

TRACEY-320982 (11/21/2010)

With this information would you be able to replicate the data to another database. Most of the software we use does not have primary keys so SQL Replication is not an option.

Mirroring, snapshots not an option as the reporting database needs to be up 24 /7 and not down whilst snapshots run or log transactions are built on the reporting database.

Just curious

Not a good idea to build production functionality on undocumented features.

Post #1024626

GSquared

Posted Monday, November 22, 2010 1:58 PM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

fn_dblog changed slightly between SQL 2005 and SQL 2008. This was, of course, without notification or documentation. If I remember correctly, it changed from 2000 to 2005 as well. I don't know if it's changed from 2008 to 2008 R2, but it could have. Also haven't checked Denali (SQL v 11) yet.

I've used it to test for whether a log backup was needed on databases that have intermittently high activity in long periods of no activity, comparing LUNs in the log to data in the backup history in msdb. Even then, I wouldn't use it in anything where an error message mattered much. Too much chance of it changing again.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1024675

« Prev Topic | Next Topic »

44 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions