Solved

List of SQL Server Error Log text files

Posted on 2011-09-19
5
238 Views
Last Modified: 2012-05-12
Hi All,
I can look at eventviewer for alerts registered on my SQL server 2008  or use xp_readerrorlog to retrieve lines of error log.

But I am after something else.
We have a central linux log monitoring system which can process text files and raise alerts for issues. I wish to move SQL server log files (text files) to a linux node & process them there as we do for Oracle , Websphere & some others.

I am looking for list of all SQL server warning,error log files and keywords to search for to locate issues.

Many Thanks
0
Comment
Question by:crazywolf2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 36558977
View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files

refer
http://msdn.microsoft.com/en-us/library/ms187885.aspx
0
 

Author Comment

by:crazywolf2010
ID: 36559010
Hi Ppratima_mcs,
I am aware of this file and in fact xp_readerrorlog return those details.

The question I have , is that the only log file  available under SQL Server for any kind of errors.
What kind of keywords should be searched (using grep to say there is a warning or an error.

Many Thanks
0
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 36559030
ok you want list for eoors
something like this

SQL Server Error Message - Errors 1 to 500

http://www.sql-server-helper.com/error-messages/msg-1-500.aspx
0
 
LVL 5

Expert Comment

by:AlokJain0412
ID: 36559123
Folloing the Link Which is Explained You  and all of  your queies Related to Manage Multipel server Error Reading


How to consolidate your Error Log All SQL Servers

http://www.simple-talk.com/sql/ssis/consolidating-sql-server-error-logs-from-multiple-instances-using-ssis/

Let me Know please
0
 
LVL 10

Accepted Solution

by:
Ramesh Babu Vavilla earned 500 total points
ID: 36559260
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question