January 16, 2013 at 5:49 pm
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
January 16, 2013 at 6:23 pm
Are you storing the data from all the SQL log files in a table on the Centralized server?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 16, 2013 at 8:39 pm
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.
January 17, 2013 at 12:52 pm
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[/url]
Joie Andrew
"Since 1982"
January 17, 2013 at 4:01 pm
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.
January 17, 2013 at 4:13 pm
Can you share your powershell script?
Thanks,
January 17, 2013 at 4:25 pm
Sorry, I have IP constraints.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply