none
Service Broker manager has shut down RRS feed

  • 问题

  • Date,Source,Severity,Message

    08/09/2014 07:44:21,spid7s,Unknown,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
    08/09/2014 07:44:21,spid7s,Unknown,SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
    08/09/2014 07:44:21,spid13s,Unknown,Service Broker manager has shut down.
    08/09/2014 07:44:19,spid52,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
    08/09/2014 07:44:19,spid52,Unknown,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    08/09/2014 07:44:19,spid52,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
    08/09/2014 07:44:19,spid52,Unknown,Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    08/09/2014 07:44:19,spid52,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
    08/09/2014 07:44:19,spid52,Unknown,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    08/09/2014 01:00:01,Backup,Unknown,Database differential changes were backed up. Database: scrat<c/> creation date(time): 2014/07/04(14:42:51)<c/> pages dumped: 1931<c/> first LSN: 192:20729:118<c/> last LSN: 192:20779:1<c/> full backup LSN: 178:6787:219<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\scrat\scrat_backup_2014_08_09_010001_0097351.bak'}). This is an informational message. No user action is required.
    08/09/2014 00:00:29,spid17s,Unknown,This instance of SQL Server has been using a process ID of 31636 since 7/3/2014 3:45:27 PM (local) 7/3/2014 7:45:27 AM (UTC). This is an informational message only; no user action is required.

    哪位高手帮忙看下,sqlsserver 2008R2 (windows 2008 )为何异常终止,谢谢!

    2014年8月11日 3:09

答案

  • 08/09/2014 07:44:21,spid7s,Unknown,SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
    08/09/2014 07:44:21,spid13s,Unknown,Service Broker manager has shut down.

    -------------------- 看这个, 应该是 SQL Server收到了 Stop 的需求,这个应该是停止 SQL 服务造成的,停止的原因可能是系统重启,SQL 服务重新启动,或者是直接停止SQL服务

    你可以检查一下操作系统上的日志

    2014年8月11日 5:39

全部回复

  • Someone stopped sql or rebooted machine, check windows event log to confirm.
    2014年8月11日 3:22
  • 08/09/2014 07:44:21,spid7s,Unknown,SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
    08/09/2014 07:44:21,spid13s,Unknown,Service Broker manager has shut down.

    -------------------- 看这个, 应该是 SQL Server收到了 Stop 的需求,这个应该是停止 SQL 服务造成的,停止的原因可能是系统重启,SQL 服务重新启动,或者是直接停止SQL服务

    你可以检查一下操作系统上的日志

    2014年8月11日 5:39
  • Unknown,SQL Trace was stopped due to server shutdown

    这不是很明显吗。看一下你的WINDOWS日志为什么SQL Server服务异常关闭。


    Please Mark As Answer if it is helpful.

    2014年8月12日 3:52