asked on

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.

chapmandew

You can't. Ms doesn't publish thhe methods to read the files other than to ISVs

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

websauce

ASKER

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?

chapmandew

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

websauce

ASKER

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?

SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

websauce

ASKER

ha ha. i got pwnd.