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 |
|
gargmanoj
Starting Member
7 Posts |
 Posted - 2005-07-17 : 15:25:00
|
| Hi everyone,I am newb to sqlserver n i m doing a project for damage confinement in datbases. for that i need to read sql server 2000 's database logs.as from those logs i want to know what information r stored there. I had tried to read using DBCC command but it only gives data in binary format plz tell me a way to read logs in readable form. i cant use ant tool for doing this since in my project i will be reading logs time by time n it will be an automated process.any kind of help is appreciated. thanx a lot in advance. my emailid is gargmanoj@gmail.com.plz reply asap. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-07-17 : 15:57:52
|
| Except for DBCC LOG, the only other method available is to use something like Lumigent's Log Explorer:http://www.lumigent.com/ |
 |
|
|
gargmanoj
Starting Member
7 Posts |
Posted - 2005-07-18 : 01:56:52
|
| but BDCC log gives it in binary form can i get log in readable format using BDCC log.Some one told me that thr is an indirect method of getting logs using some sort of replication of database.but i was not able to get the trick.plz tell me a way.thanx in advnce |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-07-18 : 08:02:59
|
| Read my previous reply. |
|
|
|
|
|
|
Plz any one help me out