June 26, 2008 at 10:53 am
Hello,
I have a database in Simple recovery model. Is there a way to check its transaction log for query statements?
Also, can one copy the transaction log file directly or is it necessary to back up the transaction log?
I want to see if there is anything in the transaction log of interest without accidentally wiping out any data that happens to still be available.
Thanks for any help.
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 26, 2008 at 11:58 am
If the database is in Simple Recovery, no, you don't have anything of any interest in the transaction log. It only holds onto transactions till they commit, then junks them. (Well, that's a little over-simplified, but it's pretty much what's going on.)
You can use a log parser on an active transaction log to see what's in it. ApexSQL has one that's pretty good. Lumigent has another. RedGate has one that works on SQL 7 and 2000, but not on 2005 (theirs is free, though). The Apex one has a free trial, if you want to give it a shot.
- 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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply