By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

View SQL transaction log details

P: n/a
I have a client site running SQL 2000. It seems some data rows have
been deleted and several tables have been dropped. I have a current db
backup which contains a 34GB log file, but I don't know how to view it.
Is there any way to search through the log file and determine when the
data was lost or what process/user dropped the tables?

Thanks,
Tull.

May 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
tull (tu******@gmail.com) writes:
I have a client site running SQL 2000. It seems some data rows have
been deleted and several tables have been dropped. I have a current db
backup which contains a 34GB log file, but I don't know how to view it.
Is there any way to search through the log file and determine when the
data was lost or what process/user dropped the tables?


Yes, but it takes a third-party tool to do it. Two I know of are Lumigent
Log Explorer, http://www.lumigent.com and Log PI, http://www.logpi.com.

There is a undocumented DBCC command, DBCC LOG, but it's very difficult
to make out any sense of that output.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.