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 |
|
rauk10
Starting Member
16 Posts |
 Posted - 2008-09-23 : 10:36:37
|
| Hi everyone I am a newbie. I have one question.I want to check the log files. So whenever any data modification happens in the database, it is written in the transaction log. So how could we check the log files? I want to know what updates had happened in the log, what are the data added, what are deleted.Is there a direct method to look at the log files or I have to use any 3rd party tool? And what are the steps involved in it.I would really appreciate if you could tell me how to do that.Thank You. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-23 : 10:37:56
|
| Yes you need thrid-party tools for it like Log Luminent Explorer. |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-01 : 21:23:13
|
| I'm wondering why you want to buy tool for looking at log files. I understand your objective but logging depends on database recovery model settings it may not log everything. You can set up a light weight black box trace to capture code. |
|
|
|
|
|
|
How to check the log files