Post reply

Log files under manage

  • October 13, 2006 at 2:18 pm

    #174867

    Hi all

    I am wondering when you are looking in Enterprise manager and you go to Management->SQL Server Logs

    I have been told by my boss that only the errors are logged here.  But I have been looking at all the event in this log I believe that both success and failures are both logged here.  When looking at the logs I see things that look like it was completed successfully like the backups.

    any light that can be shined on this would be appreciated

    Thanks

    Were using SQL Server 2000 sp 4

  • October 13, 2006 at 3:53 pm

    #665854

    BOL defines the SQL Server Error log as "logs certain system events and user-defined events".  What it does is log events (errors and informational) based on the messages severity level.  You can adjust this severity level logging, adjust the severity level of the message itself, and create new messages with your own severity levels to enter in the log.

    Look in BOL for Error Logs and sys.messages for more info on how to manage these.

    Hope this helps



    Mark

  • October 13, 2006 at 3:58 pm

    #665855

    Thanks Mark

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply