[Top] [All Lists]

RE: SQL Error Log is not logging events properly

Subject: RE: SQL Error Log is not logging events properly
From: "Andy Davis"
Date: Fri, 18 Nov 2005 00:38:03 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs,, microsoft.public.sqlserver.server
its really strange , yeah please look at C2 Auditing : ad_security_46av.asp ad_config_09yd.asp ad_security_2ard.asp scid=kb;en-us;93362 prodtech/dbsql/sqlc2.mspx prodtech/dbsql/sql2kaud.mspx
Andy Davis
Active Crypt Team
  Server Encryption Decryption Software

"Andy S." wrote:

>     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. 

<Prev in Thread] Current Thread [Next in Thread>