Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Reading SQL Server's Transaction Log Expand / Collapse
Author
Message
Posted Monday, November 22, 2010 8:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:39 AM
Points: 109, Visits: 606
DBCC PAGE is undocumented as well. Use at your own risk.
Post #1024387
Posted Monday, November 22, 2010 8:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 19, 2014 9:26 AM
Points: 312, Visits: 1,028
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
Posted Monday, November 22, 2010 11:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 14, 2012 4:51 PM
Points: 14, Visits: 53
SRD?
Post #1024524
Posted Monday, November 22, 2010 11:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 3:53 PM
Points: 8, Visits: 263
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
Posted Monday, November 22, 2010 11:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 3:53 PM
Points: 8, Visits: 263
Systems Research & Development (SRD) founded by Jeff Jonas.
Post #1024552
Posted Monday, November 22, 2010 11:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, November 22, 2010 11:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 3:53 PM
Points: 8, Visits: 263
Not sure. It was folded into IBM and I haven't seen any other information about their log reading tech.
Post #1024564
Posted Monday, November 22, 2010 12:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 9, 2014 6:46 AM
Points: 5, Visits: 161
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
Posted Monday, November 22, 2010 1:06 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:20 PM
Points: 1,276, Visits: 1,135
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
Posted Monday, November 22, 2010 1:58 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
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 »

Add to briefcase ««12345»»»

Permissions Expand / Collapse