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 |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2007-02-07 : 23:36:43
|
| does anyone know how i may make tlogs a little more friendly to read?i tried using DBCC log ,but its impossible to understand |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-07 : 23:43:39
|
| what are you trying to do? If you are trying to pull data from the logfiles (to recreate a drop table, or restore missing data for example) you can use 3rd party tools like lumigent log explorer or red-gate sql log rescue.-ec |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-02-07 : 23:52:49
|
| yeah im just preparing something just incase there comes a time we need to recover , so there is no way of viewing the logs in an understandable manner just to undertstand the type of logs occuring on db for now? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-07 : 23:55:07
|
quote:
Originally posted by rnbguy
yeah im just preparing something just incase there comes a time we need to recover , so there is no way of viewing the logs in an understandable manner just to undertstand the type of logs occuring on db for now?
nope. you need to use a 3rd party tool. I have used both tools in the past, and have found that they both work similarly.-ec |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-02-08 : 00:01:38
|
| thank you, your help is greatly appreciated |
|
|
|
|
|
|
making transaction logs more friendly...