Understand that by default SQL Server has 7 error logs.
The oldest error log records will be deleted each time after SQL Server restarts.
I'm looking for a solution that will retain the error logs for one year. (due to some security policy)
Increasing the number of error logs doesn't help much as I won't be able to determine how many times SQL Server will be restarted a year.
Anyone have solution to it on how can I have a rule to only remove error logs older than one year?