How I read LDF files without access to SQL server or an expensive 3rd party application.

I am trying to view the contents of an LDF file from SQL 2000.  I do not have access to the SQL server from which the LDF file came from, so I'm not sure how to use the DBCC commnd. (no access to query analyzer).

The other solution on experts-exchange recommends a product from lunigen that is no longer available.  also, we don't have a budget to buy a thousand dollar piece of software to read the log files.

essentially, the SQL box was compromised and I want to see what queries were run against the DB before it was taken offline.


I'm open to other suggestions of how to find the last queries that were run against the DB.

LVL 1
websauceAsked:
Who is Participating?
 
Anthony PerkinsCommented:
You are SOL.
0
 
chapmandewCommented:
You can't. Ms doesn't publish thhe methods to read the files other than to ISVs
0
 
websauceAuthor Commented:
If I had access to SQL server, is it possible to use the DBCC  command to produce a "readable" log file where I can see what queries were run against a DB in a time range?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
chapmandewCommented:
>>If I had access to SQL server, is it possible to use the DBCC  command to produce a "readable" log file where I can see what queries were run against a DB in a time range?

Nope.
0
 
websauceAuthor Commented:
maybe I'm asking the wrong question.
is there a way to see a list of queries that were run against a DB for a specific  time period?
0
 
chapmandewCommented:
No, not if you did not capture them already.  You could have captured them in a server-side trace, but you'd have to have it already setup.  They are stored in the log files (DML statements, NOT SELECT statements)...but, you'd need a log reader to get to them.

So, unfortunately, the answer is still no.
0
 
websauceAuthor Commented:
ha ha. i got pwnd.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.