If you run into the issue of looking at the Errorlog in SSMS and seeing this:

ErrorLog

You might start to worry about whats going on but don’t! You can still get the current and historic errorlog data via TSQL with something like this, which frankly is a better way to read the errorlog as it allows you to filter and refine the results.The resolution is pretty simple. Restart the agent.

Advertisements