View transaction log file of size 2 gb.

18 Dec 2006 6:58 AM

Bhaskara

Hi All,

I have a log file of size 2 gb. I want to view last month transactions.
How can I view this information.

When I tryied to open this file, my system/application is hanging as
this file is too big.

How can I open this file (or) how can I view log detaiils for a
particular period.

I am using SQL Server 2000 database.

Regards,
Bhaskara.

18 Dec 2006 7:51 AM

Arnie Rowland

If you are referring to the Transaction Log, you will need to find one of
the third party log tools.

Try:

ApexSQL
Red-Gate
Lumigent

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

Show quote

"Bhaskara" <bhaskarare***@gmail.com> wrote in message
news:1166425094.677065.74270@l12g2000cwl.googlegroups.com...
> Hi All,
>
> I have a log file of size 2 gb. I want to view last month transactions.
> How can I view this information.
>
> When I tryied to open this file, my system/application is hanging as
> this file is too big.
>
> How can I open this file (or) how can I view log detaiils for a
> particular period.
>
> I am using SQL Server 2000 database.
>
>
> Regards,
> Bhaskara.
>