I have a server where the sql error log is constantly missing events.
Usually you see when processes were killed, backups, server reboots, etc. I
have a SQL 2000 SP 3a server that is logging when databases start, a few of
the database backups, but nothing about processes being killed. The only
thing I can think of is that auditing is not turned on. Any suggestions? I
tried cycling the error log, it put an entry that the error log had been
cycled, then all the SQL server info. I am waiting to see if that does
anything.
>> Stay informed about: SQL Error Log is not logging events properly