Solved

List of SQL Server Error Log text files

Posted on 2011-09-19
5
235 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
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:
sqlservr earned 500 total points
ID: 36559260
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Question 5 36
SQL Server Count where two id types exist in column 8 27
SQL Help 27 45
SQL Syntax: How to force case sensitive query? 2 26
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 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