Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2009-05-19 : 08:15:28
|
| Does anyone happen to know of a tool that will do a transaction log audit without the original full backup? I have a bunch of tlogs that I want to look @, but dont have the full db backup from the start of the day. |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-19 : 23:44:15
|
| You can look at the trace files....select * from sys.traces or even set up black box on SQL 2005 this captures more statements that are occuring on the server. |
 |
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-05-20 : 09:28:56
|
| Sorry, maybe I wasnt clear, these transactions logs are from three months ago, I was trying to find out of a tool that might be able to look @ these specific files, and allow me to investigate them |
|
|
|
jholovacs
Posting Yak Master
163 Posts |
Posted - 2009-05-20 : 13:00:35
|
I think Red Gate or Quest has a tool that will do that, but as I recall it was not cheap.
SELECT TOP 1 w.[name]FROM dbo.women wINNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_idWHERE i.net_worth > 10000000 AND i.status IN ('dead', 'dying') AND w.husband_id IS NULLORDER BY w.hotness_factor DESC |
|
|
|
|
|
|
Transaction Log Audit