InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 06:00:35 GMT20http://www.sqlservercentral.com/Forums/Topic1233821-360-1.aspx[quote][b]Grant Fritchey (1/11/2012)[/b][hr]But you have a good backup you can go to and retrieve everything, right?If not, why not?[/quote]Yes Grant, absolutely :-)Wed, 11 Jan 2012 21:15:54 GMTmohammed moinudheenhttp://www.sqlservercentral.com/Forums/Topic1233821-360-1.aspxBut you have a good backup you can go to and retrieve everything, right?If not, why not?Wed, 11 Jan 2012 06:23:32 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1233821-360-1.aspxI agree with Gail in your case. Just for your reference, you may keep this link handy for future use.[url=http://www.sqlskills.com/BLOGS/PAUL/post/Finding-out-who-dropped-a-table-using-the-transaction-log.aspx]Finding out who dropped the table using transaction log[/url]Wed, 11 Jan 2012 04:08:06 GMTmohammed moinudheenhttp://www.sqlservercentral.com/Forums/Topic1233821-360-1.aspxThen the drop table log records are no longer in the transaction log (its a transaction log for database recovery, not an audit log) and, unless you had some other form of auditing you won't be able to tell who dropped it.Wed, 11 Jan 2012 03:57:33 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1233821-360-1.aspxMany thanks for your prompt response. I installed it and used it to read the LDF file. Now the problem is that although I am sure that the Table was created many years ago, the transactions shown start from 09/01/2012 10:41 and the table is dropped between 4:00 AM and 6:30 AM on 09/01/2012Wed, 11 Jan 2012 03:51:02 GMTmaryamzolfagharhttp://www.sqlservercentral.com/Forums/Topic1233821-360-1.aspxFor SQL 2000 you can get SQLLogRescue from Redgate (it's free), but depending how long ago the table was dropped, it may not be in the tran log any longerWed, 11 Jan 2012 03:14:52 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1233821-360-1.aspxHow can I read LDF file? My table is missing from database, and I want to know how it has been removed. Therefore I need to read the transactions registered in LDF fileWed, 11 Jan 2012 02:55:29 GMTmaryamzolfaghar