sql server (alternate): 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.

tull (tullrong@gmail.com) writes:
[quoted text, click to view]

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