Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 HOW To Open Transaction Log file

Author  Topic 

cshekar
Starting Member

49 Posts

Posted - 2001-12-21 : 11:21:06
I wanted open my Trancation log Backup file which is 15GB Big file.
so Can any one tell me how to open that file if I open with Notepad
it will not open because is so big.
and also I wanted see what are all the transaction but I can not see that.

Thanks



chandra shekar

robvolk
Most Valuable Yak

15732 Posts

Posted - 2001-12-21 : 11:36:11
The format of the log file is such that even if you opened it with such a program, you'd never be able to make sense of it.

You can download Log Explorer from www.lumigent.com , this is a nice program that examines the transaction log and lets you browse it or perform recovery operations. This is much better than any other method.

Go to Top of Page

cshekar
Starting Member

49 Posts

Posted - 2001-12-21 : 12:33:56
Thanks


chandra shekar
Go to Top of Page
   

- Advertisement -