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!
> >>
> >>
> >>
>
>