transaction logs

[rsx]

Hello, I have recently noticed a fair bit of data missing from a table in one of my databases. Is there a way to view the transaction log file for a particular time period to determine who or what deleted these records?

 

[druer]

There are tools on the market that you can purchse to do just what you are looking to do, however, there is no FREE way to do that kind of thing. The tool vendors likely offer a review period to decide whether you want to purchase or not. Do a search on Google for "transaction log viewer sql server" or something similar to find the products.

 

[mrdenny]

You are looking for a product called Log Explorer by Lumigent Technologies (

http://www.lumigent.com).

You can use the free version to view only Northwind and Pubs. It's a good product.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLDenis]

You can use the free version to view only Northwind and Pubs. It's a good product.

So if you renamed your database to pubs (if you can do this of course since I assume the db is in use) then would that product work on the db?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[druer]

Ooooh Denis that's a sneeky idea.

 

[SQLDenis]

sneaky? yes
unethical? probably
illegal? I don't think so (haven't read the license)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ShankarJ]

Check out SQL Log Rescue from

http://www.red-gate.com.

They have a eval version and are reasonable priced.

 

[rsx]

Thank you everyone for your replies! Very helpful