Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to read LDF file? sql 2000 Expand / Collapse
Author
Message
Posted Wednesday, January 11, 2012 2:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Wednesday, January 11, 2012 3:14 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 40,199, Visits: 36,601
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
Posted Wednesday, January 11, 2012 3:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Wednesday, January 11, 2012 3:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 40,199, Visits: 36,601
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
Posted Wednesday, January 11, 2012 4:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:12 PM
Points: 2,278, Visits: 3,798
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
Posted Wednesday, January 11, 2012 6:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 13,890, Visits: 28,285
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 Query Performance Tuning
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
Posted Wednesday, January 11, 2012 9:15 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:12 PM
Points: 2,278, Visits: 3,798
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


Mohammed Moinudheen
Post #1234515
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse