i have ms sql 2008 r2 express. can i use kiwi syslog server for tracking sql transaction log of my database and how? some guide or manual?
I had a similar need where i wanted to create syslog alerts based on certain query results. I had to write my own dll and since 2008R2 and below use .net 2.0 I was pretty limited. I ended up writing a dll that sends the syslog request to a webservice that generated the syslog message to my kiwi server.
The first question to answer is "is the SQL transaction log a text log file"? If so NXlog, and others, can read it into a syslog server. From some quick searching it appears it is not an actual log file. It seems to be another, special, database table that is not designed for external uses. I'm not a DBA and have never used SQL Server so this may not be 100% accurate.
The second question is "what information are you trying to report on"? It may be possible to export the data via SQL commands but that's way outside my expertise.
Looking for the perfect transaction log reader then you can use SQL Server Transaction Log Reader. It helps you to repair the corrupted transaction log file of the server. The software can also repair the corrupted LDF files. Any new user can easily use the SQL server log analyzer because the software has an interactive user interface.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.