Tag Archives | ErrorLogs

Querying SQL Error Logs With PowerShell

It’s a real pain trying to get data out of the SQL Error Logs I’ve noticed. You either don’t cycle your files very often and end up with stupid amounts of data in there to sift through or you cycle them frequently and then you end up having to try and figure out which of […]

Continue Reading 0

Reading SQL Server Error Logs Using PowerShell

I was messing around with PowerShell the other day and using it to read SQL Server error logs. It’s actually a pretty trivial thing. From SQLPLS $Logs = DIR SQLSERVER:SQLLOCALHOST $Logs.ReadErrorLog() Quick and easy. Then I tried to read from a clustered instance of SQL Server and ran into an issue $Logs = DIR SQLSERVER:SQLCLUSTEREDINSTANCE […]

Continue Reading 0