Read the database transaction log file ie LDF file

Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
PushkarThere are various third-party tools that can help.
LogPI, Log Explorer, etc.
Recently I've been using Red Gate's tool quite a bit... I think it's a bit s
impler to use than the other available tools:
http://www.red-gate.com/sql/sql_log_rescue.htm
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Pushkar" <pushkartiwari@.gmail.com> wrote in message news:OOFQjIMqFHA.904@.TK
2MSFTNGP10.phx.gbl...
Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
Pushkar|||Use a third party tool.
http://www.aspfaq.com/2449
"Pushkar" <pushkartiwari@.gmail.com> wrote in message
news:OOFQjIMqFHA.904@.TK2MSFTNGP10.phx.gbl...
Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
Pushkar|||You can use the undocumented command DBCC LOG. See:
[url]http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp[/ur
l]
A better approach would be to use a third-party tool, such as
Lumigent Log Explorer, ApexSQL Log or Red-Gate SQL Log Rescue.
Razvan

read out transaction log

Hello!
is there a possibility to get all transactions between two dates out of
transaction log, an then inject this data into a new database? i need the
data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
available - was before this time, so all changes must be in the transaction
log.
the structure is known and reproducable.
Database recovery mod is full.
Thank you!Hi Marcus
You can do this using the tools you have already mentioned in your previous
posts. If you have truncated the log then they will no longer be recoverable.
In your current situation it is probably be worthwhile opening a call with
PSS.
John
"Marcus Pink" wrote:
> Hello!
> is there a possibility to get all transactions between two dates out of
> transaction log, an then inject this data into a new database? i need the
> data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
> available - was before this time, so all changes must be in the transaction
> log.
> the structure is known and reproducable.
>
> Database recovery mod is full.
> Thank you!
>
>|||Hi John,
the log file should not be truncated, but i've tried several programs with
no luck.
Is it possible to check if the file is truncated?
Open a call with PSS? Whats that? I don't know this.
Marcus
"John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
news:F94DB8AC-CFD3-48A3-B5F6-4DD57E85F8FF@.microsoft.com...
> Hi Marcus
> You can do this using the tools you have already mentioned in your
> previous
> posts. If you have truncated the log then they will no longer be
> recoverable.
> In your current situation it is probably be worthwhile opening a call with
> PSS.
> John
> "Marcus Pink" wrote:
>> Hello!
>> is there a possibility to get all transactions between two dates out of
>> transaction log, an then inject this data into a new database? i need the
>> data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
>> available - was before this time, so all changes must be in the
>> transaction
>> log.
>> the structure is known and reproducable.
>>
>> Database recovery mod is full.
>> Thank you!
>>|||Hi Marcus
DBCC SQLPERF ( LOGSPACE ) will give you some idea of what is being used, but
it will not give you the detail you require. Using a program such as the
lumigent log explorer you should be able to browse what is in the log. A 600
MB file would take some time to process, but filtering on a very short date
range and specific tables may help.
PSS is Microsoft Product Support, raising an incident will cost you see
https://support.microsoft.com/oas/default.aspx?&c1=508&gprid=2852&
John
"Marcus Pink" wrote:
> Hi John,
> the log file should not be truncated, but i've tried several programs with
> no luck.
> Is it possible to check if the file is truncated?
> Open a call with PSS? Whats that? I don't know this.
>
> Marcus
> "John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
> news:F94DB8AC-CFD3-48A3-B5F6-4DD57E85F8FF@.microsoft.com...
> > Hi Marcus
> >
> > You can do this using the tools you have already mentioned in your
> > previous
> > posts. If you have truncated the log then they will no longer be
> > recoverable.
> >
> > In your current situation it is probably be worthwhile opening a call with
> > PSS.
> >
> > John
> >
> > "Marcus Pink" wrote:
> >
> >> Hello!
> >>
> >> is there a possibility to get all transactions between two dates out of
> >> transaction log, an then inject this data into a new database? i need the
> >> data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
> >> available - was before this time, so all changes must be in the
> >> transaction
> >> log.
> >>
> >> the structure is known and reproducable.
> >>
> >>
> >> Database recovery mod is full.
> >>
> >> Thank you!
> >>
> >>
> >>
>
>

Read from tables when another transactions isolationlevel is ReadCommited

I need to be able to read from tables while a transaction is running. This
transaction could take 20-30 minutes. I don't want to be able to read
uncommitted data that has been written in this transaction though.
I looked at NOLOCK but that says it reads uncommitted data.
Any suggestions?READPAST allows you to read past the locked rows.
Keith
"Joe" <J_no_spam@._no_spam_Fishinbrain.com> wrote in message
news:eLo9e5$SFHA.2096@.TK2MSFTNGP14.phx.gbl...
>I need to be able to read from tables while a transaction is running. This
> transaction could take 20-30 minutes. I don't want to be able to read
> uncommitted data that has been written in this transaction though.
> I looked at NOLOCK but that says it reads uncommitted data.
> Any suggestions?
>|||With nolock you could read dirty rows. In this case you'd be safe to read
committed.
"Joe" <J_no_spam@._no_spam_Fishinbrain.com> wrote in message
news:eLo9e5$SFHA.2096@.TK2MSFTNGP14.phx.gbl...
>I need to be able to read from tables while a transaction is running. This
> transaction could take 20-30 minutes. I don't want to be able to read
> uncommitted data that has been written in this transaction though.
> I looked at NOLOCK but that says it reads uncommitted data.
> Any suggestions?
>|||If the isolation level is set to ReadCommited for the transaction, does that
cause the table to lock or just the rows being inserted, updated?
If it only effects the inserted and updated then the READPAST will work.
Is there anyway to perform the write while within a transaction without
locking the tables at all?
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uRnvitATFHA.3152@.TK2MSFTNGP12.phx.gbl...
> READPAST allows you to read past the locked rows.
> --
> Keith
>
> "Joe" <J_no_spam@._no_spam_Fishinbrain.com> wrote in message
> news:eLo9e5$SFHA.2096@.TK2MSFTNGP14.phx.gbl...
This
>|||Hello Joe,
Could find a solution? I've a case same with yours. READPAST works and I can
read unlocked rows. But do you know a way to also read locked rows with the
ir original (before lock) values?sql