Post reply

find errors in log file for multiple servers

  • January 16, 2013 at 5:49 pm

    #287614

    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

    #1578061

    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

    #1578072

    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

    #1578443

    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

    #1578505

    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

    #1578510

    Can you share your powershell script?

    Thanks,

  • January 17, 2013 at 4:25 pm

    #1578516

    Sorry, I have IP constraints.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy