Solved

List of SQL Server Error Log text files

Posted on 2011-09-19
5
233 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now