How to read LDF file? sql 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » How to read LDF file? sql 2000

How to read LDF file? sql 2000

Rate Topic

Display Mode

Topic Options

Author

Message

maryamzolfaghar

Posted Wednesday, January 11, 2012 2:55 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 20, 2012 1:35 AM
Points: 89, Visits: 71

How 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 file

Post #1233821

GilaMonster

Posted Wednesday, January 11, 2012 3:14 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:37 AM
Points: 38,069, Visits: 30,364

For 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 longer

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1233836

maryamzolfaghar

Posted Wednesday, January 11, 2012 3:51 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 20, 2012 1:35 AM
Points: 89, Visits: 71

Many 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/2012

Post #1233860

GilaMonster

Posted Wednesday, January 11, 2012 3:57 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:37 AM
Points: 38,069, Visits: 30,364

Then 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.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1233863

mohammed moinudheen

Posted Wednesday, January 11, 2012 4:08 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:29 PM
Points: 2,178, Visits: 3,599

I agree with Gail in your case.

Just for your reference, you may keep this link handy for future use.

Finding out who dropped the table using transaction log

Mohammed Moinudheen

Post #1233868

Grant Fritchey

Posted Wednesday, January 11, 2012 6:23 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 13,436, Visits: 25,281

But you have a good backup you can go to and retrieve everything, right?

If not, why not?

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1233926

mohammed moinudheen

Posted Wednesday, January 11, 2012 9:15 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:29 PM
Points: 2,178, Visits: 3,599

Grant Fritchey (1/11/2012)

But you have a good backup you can go to and retrieve everything, right?

If not, why not?

Yes Grant, absolutely Smile

Mohammed Moinudheen

Post #1234515

« Prev Topic | Next Topic »

Permissions