|
I'm having trouble with the SQL Server Log File Viewer on one of my servers (SQL 2005 Active/Passive cluster) not being able to read the Windows NT Event Log on the server. I'm getting an "Access Denied" error. Consequently I have to RDP to actual machine to read the Event Log [hassle]. What account does the Log File Viewer run under? Apparently it needs more rights. Any other recommendations?
(comments are locked)
|
|
There are several methods mentioned on this blog - http://thelonedba.wordpress.com/2012/09/12/querying-sql-server-event-logs-to-search-for-dbcc-checkdb-output/ from @thomasrushton. You simply need to adjust the methods to search for what you want rather than the DBCC output that the blog is focussing on My 2 pence says use Log Parser as you can very easily use it to get the log content from a large number of servers with very little alteration. Log Parser looks uber cool, I'll check it out. Thanks for taking the time to help.
Oct 13 '12 at 07:02 PM
willspurgeon
Great that you are going to try LogParser, its a great tool to understand and use. I wrote a series of blogs on it, here's a link to the first one - http://www.simple-talk.com/blogs/2010/05/24/using-logparser-part-1/. it might be of use to you but the documentation that comes with it is really comprehensive. Start a new question here anytime you want a hand.
Oct 14 '12 at 09:55 AM
Fatherjack ♦♦
(comments are locked)
|
