Posted by Trevor Best on 06/09/06 10:51

johnbandettini@yahoo.co.uk wrote:
> Trevor
>
> A backup of the transaction log will truncate the transaction log. All
> completed transactions will be removed.
>
> What are you planing to do with the transaction log? There is not a lot
> you can do with out a matching database. As far as I am aware,
> Lumigent's Log reader is the only product that can read the transaction
> log.

Hi John, thanks for the reply.

I do intend to view the log, I'm using SQLLog Rescue from
www.red-gate.com. I can connect to their server over a VPN but it took
hours to read the log and got a general network error during the
process. What I want to do is restore the database on my server c/w
logs so I can view them here.

I know I can grab the data files and attach them on my end but I would
have to wait until tonight when people are off line to free up the
files.

[Back to original message]