find errors in log file for multiple servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » find errors in log file for multiple servers

find errors in log file for multiple servers

Rate Topic

Display Mode

Topic Options

Author

Message

sqlfriends

Posted Wednesday, January 16, 2013 5:49 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:40 PM
Points: 1,631, Visits: 2,834

I would like to see if any errors in SQL log.

Is that possible using some query for all the servers in my central server management to pull it?

A query maybe looks for the word Error in the log file ?

Thanks

Post #1408112

MyDoggieJessie

Posted Wednesday, January 16, 2013 6:23 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:32 PM
Points: 2,063, Visits: 3,787

Are you storing the data from all the SQL log files in a table on the Centralized server?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" Wink

Post #1408116

ThomasFrost

Posted Wednesday, January 16, 2013 8:39 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 10, 2013 1:59 PM
Points: 169, Visits: 447

use the local server group in SSMS and then use something like sp_readerrorlog to seach for what your looking for, not the most elegent, but just a thought I had

No signature available.

Post #1408129

Joie Andrew

Posted Thursday, January 17, 2013 12:52 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:10 AM
Points: 578, Visits: 1,107

use the local server group in SSMS and then use something like sp_readerrorlog to seach for what your looking for, not the most elegent, but just a thought I had

I agree with this. If your servers are registered in a central management server you can write a query in a query window and execute it against all your systems. You can use sp_readerrorlog or xp_readerrorlog. I prefer using xp_readerrorlog because you can filter with a keyword.

Here is an article on the parameters you can use with xp_readerrorlog:

Reading the SQL Server log files using TSQL

Joie Andrew
"Since 1982"

Post #1408574

arnipetursson

Posted Thursday, January 17, 2013 4:01 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 143, Visits: 452

What I have done is create a powershell script that goes to all of my instances,
scans the log from a given timestamp and sends me email reports for errors of a given type.

Types:
login errors
deadlocks
backup errors
Severity > 20 (pages)
failed sa (and other elevated logins) login attempts
user defiend errors
IO errors
Other.

Post #1408654

sqlfriends

Posted Thursday, January 17, 2013 4:13 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:40 PM
Points: 1,631, Visits: 2,834

Can you share your powershell script?

Thanks,

Post #1408660

arnipetursson

Posted Thursday, January 17, 2013 4:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 143, Visits: 452

Sorry, I have IP constraints.

Post #1408666

« Prev Topic | Next Topic »

Permissions