[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

List of SQL Server Error Log text files

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
crazywolf2010
Asked:
crazywolf2010
1 Solution
 
Pratima PharandeCommented:
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
 
crazywolf2010Author Commented:
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
 
Pratima PharandeCommented:
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
 
AlokJain0412Commented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now