Error logs and Event viewer

  • My administrator rebooted the machine where sql 2k is running. Both sqlserver & agent services are setup to auto start. When he rebooted, I dont see any information in the sqlserver error log. Event viewer has the machine restart info. Is this normal? What should I do to include this to the log?

    Thanks much

  • Each time server is rebooted, A new SQL Server errorlog will be created with startup informations that indicate SQL Server is restarted. In privious errorlog, A message 'SQL Server is terminating due to 'stop' request from Service Control Manager.' tells when SQL Server was shutdown.

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

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