Scanning the Error Log with PowerShell

Posted by AllenMWhite on SQL Blog See other posts from SQL Blog or by AllenMWhite
Published on Tue, 25 Sep 2012 18:33:00 GMT Indexed on 2012/09/25 21:45 UTC
Read the original article Hit count: 204

One of the most important things you can do as a DBA is to keep tabs on the errors reported in the error log, but there's a lot of information there and sometimes it's hard to find the 'good stuff'. You can open the errorlog file directly in a text editor and search for errors but that gets tedious, and string searches generally return just the lines with the error message numbers, and in the error log the real information you want is in the line after that. PowerShell 2.0 introduced a new cmdlet...(read more)

© SQL Blog or respective owner

Related posts about Database Administration

Related posts about powershell