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.

• Next in forum: i want ot convert xml data format into the general data format
• Prev in forum: Re: Backup log - will it truncate?
• Thread view: Re: Backup log - will it truncate?

[Reply to this message]