In order to keep the SQL Server Error Log files small, we run sp_cycle_errorlog once a day on each server. I have noticed a strange behaviour where The SQL Server Log Viewer in Enterprise Manager will not display the typical list of old logs. It will only show the current one. An inspection of the physical drive shows that the log files are in fact there with the proper name and .01, .02, .03.... extensions.
This behaviour only appears to affect servers that we run the procedure sp_cycle_errorlog on. Any other server that cycles the log only on restarting SQL Server shows the list of archived log files as it should.
Has anyone seen this behaviour before? Is there any way to restore the functionality in EM and still use sp_cycle_errorlog?