| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2005-03-07 : 17:12:31
|
| Sorry if this sounds stupid...Is it possible to read the log file or the log file is only used by the system for back up purposes ?Thanks!Igor. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-07 : 18:27:09
|
| You will need a third party tool such as Lumigent's Log Explorer to read the tlog.Tara |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-03-07 : 19:00:36
|
| yeah Tara, I realized that after a research...Could you guys rate what you guys have tried? It's Apex good ? I need something that goes deep in the details of Schema changes more than data changes.Thanks in advance!Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-07 : 19:07:13
|
| I've actually never had to use these tools before. But why do you need to track the schema changes? How many different people are able to do this? Are non-DBAs making db schema changes?Tara |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-03-07 : 19:19:59
|
| It's a long story, that even gets a little political in the company that I work for, we had (as of this morning) a few employess with Admin access and I had 3 jobs that failed this morning, due to a table change Friday, and we can't tell who did the changes, we need to buy one of these tools...Thanks!Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-07 : 19:25:34
|
| If I were you, I'd be running SQL Profiler then to capture this.Tara |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-08 : 02:53:32
|
| yap, Apex is good, it has saved me some thousands of records that were "accidentally" deleted by some programmer.their techsupport is nice too, very courteous and accomodating--------------------keeping it simple... |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-08 : 10:21:07
|
| Lumigent Log Explorer works great as well, provided you have the recovery mode set to full. It's pretty simple to use, and they have a trial copy for download.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-03-08 : 11:20:37
|
| Great, I'll try those 2 during the weekend.Thanks!Igor. |
|
|
|
|
Reading the Log File