I wasn't sure where to post this question. If this is not the right place, kindly point me in the right direction.
We have SQL Server 2012 and 2014 on-prem. My intention was to forward the error logs to another server. Based on my search, I keep running into what's called an alerts management server. I also found that I can designate the receiving server from this article in Step 5.
However, I'm not too sure that I'm on the right track and is the reason I'm posting these questions:
- Are there other alternatives to forward SQL error logs to a centralized location (something like WEF/WEC)? Or is this the only way?
- The 2nd article states,
the alerts management server must be a default instance of SQL Server. What does this mean?
- Can I forward this to a server of my choosing? I'm not sure how SSMS would be able to list the server I want to be the receiver (maybe dependent on the 2nd bullet).