Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

List of SQL Server Error Log text files

Posted on 2011-09-19
5
Medium Priority
?
240 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 2000 total points
ID: 36559260
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

719 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