Posted by Erland Sommarskog on 05/30/06 21:13

tull (tullrong@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Insert from parameters and select statement
• Prev in forum: Re: VERY chalanging question
• Thread view: Re: View SQL transaction log details

[Reply to this message]