情况是这样的，早晨起来后数据库还能正常使用。9.40的时候突然无法连接了。进服务器直接连接数据库发现也连接不上，进配置管理器所有的SQL服务都没了。没办法重启服务器后数据库又恢复正常了
2014-08-21 08:40:28.87 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
2014-08-21 08:40:28.98 Server (c) Microsoft Corporation.
2014-08-21 08:40:28.98 Server All rights reserved.
2014-08-21 08:40:28.98 Server Server process ID is 1484.
2014-08-21 08:40:28.98 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
2014-08-21 08:40:28.98 Server Authentication mode is MIXED.
2014-08-21 08:40:29.00 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2014-08-21 08:40:29.01 Server This instance of SQL Server last reported using a process ID of 2892 at 2014/8/21 8:34:10 (local) 2014/8/21 0:34:10 (UTC). This is an informational message only; no user action is required.
2014-08-21 08:40:29.01 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2014-08-21 08:40:29.09 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2014-08-21 08:40:29.09 服务器 Detected 8 CPUs. This is an informational message; no user action is required.
2014-08-21 08:40:29.21 Server Large Page Extensions enabled.
2014-08-21 08:40:29.21 Server Large Page Granularity: 2097152
2014-08-21 08:40:29.21 Server Large Page Allocated: 32MB
2014-08-21 08:40:29.42 服务器 Using locked pages for buffer pool.
2014-08-21 08:40:29.79 服务器 Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2014-08-21 08:40:30.87 服务器 Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2014-08-21 08:40:31.37 spid6s Starting up database 'master'.
2014-08-21 08:40:31.55 spid6s 29 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2014-08-21 08:40:31.59 spid6s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2014-08-21 08:40:31.60 spid6s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2014-08-21 08:40:31.91 spid6s Resource governor reconfiguration succeeded.
2014-08-21 08:40:31.92 spid6s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2014-08-21 08:40:31.93 spid6s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2014-08-21 08:40:31.94 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2014-08-21 08:40:32.16 spid6s SQL Trace ID 1 was started by login "sa".
2014-08-21 08:40:32.20 spid6s Starting up database 'mssqlsystemresource'.
2014-08-21 08:40:32.21 spid6s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2014-08-21 08:40:32.89 spid10s Starting up database 'model'.
2014-08-21 08:40:32.89 spid6s Server name is 'MASTER_SERVER'. This is an informational message only. No user action is required.
2014-08-21 08:40:32.97 spid10s Clearing tempdb database.
2014-08-21 08:40:33.14 spid10s Starting up database 'tempdb'.
2014-08-21 08:40:33.27 spid11s The Service Broker protocol transport is disabled or not configured.
2014-08-21 08:40:33.28 spid11s The Database Mirroring protocol transport is disabled or not configured.
2014-08-21 08:40:33.35 服务器 The certificate [Cert Hash(sha1) "CCEF0C78BF6AE0C58B09659191FC5A649F615F78"] was successfully loaded for encryption.
2014-08-21 08:40:33.38 服务器 Server is listening on [ 'any' <ipv6> 1433].
2014-08-21 08:40:33.38 服务器 Server is listening on [ 'any' <ipv4> 1433].
2014-08-21 08:40:33.38 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2014-08-21 08:40:33.38 服务器 Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2014-08-21 08:40:33.42 服务器 Server is listening on [ ::1 <ipv6> 1434].
2014-08-21 08:40:33.42 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2014-08-21 08:40:33.42 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2014-08-21 08:40:33.46 服务器 The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2014-08-21 08:40:33.46 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2014-08-21 08:40:33.51 spid11s Service Broker manager has started.
2014-08-21 08:40:34.22 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:34.22 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.5]
2014-08-21 08:40:34.22 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:34.22 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.12]
2014-08-21 08:40:34.22 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:34.22 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.12]
2014-08-21 08:40:34.22 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:34.22 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.5]
2014-08-21 08:40:34.22 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:34.22 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.250]
2014-08-21 08:40:35.60 spid24s A new instance of the full-text filter daemon host process has been successfully started.
9 个解决方案
#1
14-08-21 08:40:35.76 spid24s Starting up database 'msdb'.
2014-08-21 08:40:35.76 spid25s Starting up database 'ReportServer'.
2014-08-21 08:40:35.76 spid26s Starting up database 'ReportServerTempDB'.
2014-08-21 08:40:35.76 spid27s Starting up database 'chis'.
2014-08-21 08:40:35.76 spid28s Starting up database 'cpdata'.
2014-08-21 08:40:35.76 spid29s Starting up database 'mpublic'.
2014-08-21 08:40:35.76 spid31s Starting up database 'yfgl'.
2014-08-21 08:40:35.76 spid32s Starting up database 'ykgl'.
2014-08-21 08:40:35.76 spid33s Starting up database 'zygl'.
2014-08-21 08:40:35.77 spid34s Starting up database 'zygl_bak'.
2014-08-21 08:40:35.77 spid35s Starting up database 'LSEMR'.
2014-08-21 08:40:35.77 spid36s Starting up database 'tjgl'.
2014-08-21 08:40:35.77 spid37s Starting up database 'yzcx'.
2014-08-21 08:40:35.77 spid30s Starting up database 'mzsf'.
2014-08-21 08:40:35.77 spid38s Starting up database 'BI'.
2014-08-21 08:40:35.77 spid39s Starting up database 'paul_His'.
2014-08-21 08:40:35.77 spid40s Starting up database 'MZSF_ERR'.
2014-08-21 08:40:35.77 spid41s Starting up database 'test03'.
2014-08-21 08:40:35.82 spid26s 1 transactions rolled forward in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s 0 transactions rolled back in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s Recovery is writing a checkpoint in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.90 spid28s 1 transactions rolled forward in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s 0 transactions rolled back in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s Recovery is writing a checkpoint in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.94 spid41s 1 transactions rolled forward in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.00 spid38s 1 transactions rolled forward in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s 0 transactions rolled back in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s Recovery is writing a checkpoint in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s 0 transactions rolled back in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s Recovery is writing a checkpoint in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.17 spid37s 1 transactions rolled forward in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s 0 transactions rolled back in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s Recovery is writing a checkpoint in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.94 spid29s 468 transactions rolled forward in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.04 spid6s 0 transactions rolled back in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.05 spid6s Recovery is writing a checkpoint in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.31 spid31s 3 transactions rolled forward in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.34 spid24s 391 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery completed for database msdb (database ID 4) in 1 second(s) (analysis 374 ms, redo 951 ms, undo 212 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s 0 transactions rolled back in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s Recovery is writing a checkpoint in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.81 spid34s 1 transactions rolled forward in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s 0 transactions rolled back in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s Recovery is writing a checkpoint in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:38.34 spid36s 1 transactions rolled forward in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.35 spid33s Recovery of database 'zygl' (13) is 5% complete (approximately 22 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:38.41 spid40s 1 transactions rolled forward in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s 0 transactions rolled back in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s Recovery is writing a checkpoint in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s 0 transactions rolled back in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s Recovery is writing a checkpoint in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:39.42 spid30s 296 transactions rolled forward in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:39.65 spid33s Recovery of database 'zygl' (13) is 11% complete (approximately 19 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:39.72 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:35.76 spid25s Starting up database 'ReportServer'.
2014-08-21 08:40:35.76 spid26s Starting up database 'ReportServerTempDB'.
2014-08-21 08:40:35.76 spid27s Starting up database 'chis'.
2014-08-21 08:40:35.76 spid28s Starting up database 'cpdata'.
2014-08-21 08:40:35.76 spid29s Starting up database 'mpublic'.
2014-08-21 08:40:35.76 spid31s Starting up database 'yfgl'.
2014-08-21 08:40:35.76 spid32s Starting up database 'ykgl'.
2014-08-21 08:40:35.76 spid33s Starting up database 'zygl'.
2014-08-21 08:40:35.77 spid34s Starting up database 'zygl_bak'.
2014-08-21 08:40:35.77 spid35s Starting up database 'LSEMR'.
2014-08-21 08:40:35.77 spid36s Starting up database 'tjgl'.
2014-08-21 08:40:35.77 spid37s Starting up database 'yzcx'.
2014-08-21 08:40:35.77 spid30s Starting up database 'mzsf'.
2014-08-21 08:40:35.77 spid38s Starting up database 'BI'.
2014-08-21 08:40:35.77 spid39s Starting up database 'paul_His'.
2014-08-21 08:40:35.77 spid40s Starting up database 'MZSF_ERR'.
2014-08-21 08:40:35.77 spid41s Starting up database 'test03'.
2014-08-21 08:40:35.82 spid26s 1 transactions rolled forward in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s 0 transactions rolled back in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s Recovery is writing a checkpoint in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.90 spid28s 1 transactions rolled forward in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s 0 transactions rolled back in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s Recovery is writing a checkpoint in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.94 spid41s 1 transactions rolled forward in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.00 spid38s 1 transactions rolled forward in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s 0 transactions rolled back in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s Recovery is writing a checkpoint in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s 0 transactions rolled back in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s Recovery is writing a checkpoint in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.17 spid37s 1 transactions rolled forward in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s 0 transactions rolled back in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s Recovery is writing a checkpoint in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.94 spid29s 468 transactions rolled forward in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.04 spid6s 0 transactions rolled back in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.05 spid6s Recovery is writing a checkpoint in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.31 spid31s 3 transactions rolled forward in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.34 spid24s 391 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery completed for database msdb (database ID 4) in 1 second(s) (analysis 374 ms, redo 951 ms, undo 212 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s 0 transactions rolled back in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s Recovery is writing a checkpoint in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.81 spid34s 1 transactions rolled forward in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s 0 transactions rolled back in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s Recovery is writing a checkpoint in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:38.34 spid36s 1 transactions rolled forward in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.35 spid33s Recovery of database 'zygl' (13) is 5% complete (approximately 22 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:38.41 spid40s 1 transactions rolled forward in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s 0 transactions rolled back in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s Recovery is writing a checkpoint in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s 0 transactions rolled back in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s Recovery is writing a checkpoint in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:39.42 spid30s 296 transactions rolled forward in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:39.65 spid33s Recovery of database 'zygl' (13) is 11% complete (approximately 19 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:39.72 登录 错误: 18456，严重性: 14，状态: 38。
#2
2014-08-21 08:40:39.72 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.3]
2014-08-21 08:40:39.76 spid32s 2 transactions rolled forward in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:39.90 spid39s 841 transactions rolled forward in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s 0 transactions rolled back in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s Recovery is writing a checkpoint in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database paul_His (database ID 19) in 2 second(s) (analysis 194 ms, redo 1956 ms, undo 591 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s 0 transactions rolled back in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery is writing a checkpoint in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database ykgl (database ID 12) in 1 second(s) (analysis 59 ms, redo 80 ms, undo 723 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:41.43 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:41.43 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.12]
2014-08-21 08:40:42.16 spid27s 2771 transactions rolled forward in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s 0 transactions rolled back in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery is writing a checkpoint in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery completed for database chis (database ID 7) in 3 second(s) (analysis 2041 ms, redo 789 ms, undo 208 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s 1 transactions rolled back in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s Recovery is writing a checkpoint in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.37 spid6s Recovery completed for database mzsf (database ID 10) in 5 second(s) (analysis 60 ms, redo 1448 ms, undo 3997 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.60 spid35s 405 transactions rolled forward in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s 0 transactions rolled back in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery is writing a checkpoint in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery completed for database LSEMR (database ID 15) in 4 second(s) (analysis 1000 ms, redo 3302 ms, undo 474 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:46.62 spid33s 844 transactions rolled forward in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s 0 transactions rolled back in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery is writing a checkpoint in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery completed for database zygl (database ID 13) in 10 second(s) (analysis 2656 ms, redo 7270 ms, undo 445 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:47.39 spid6s Recovery is complete. This is an informational message only. No user action is required.
2014-08-21 08:40:48.49 spid54 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.51 spid54 Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.78 spid54 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.83 spid54 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.97 spid54 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.99 spid54 Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2014-08-21 09:57:40.56 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:57:40.60 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.04 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.23 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 08:40:39.76 spid32s 2 transactions rolled forward in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:39.90 spid39s 841 transactions rolled forward in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s 0 transactions rolled back in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s Recovery is writing a checkpoint in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database paul_His (database ID 19) in 2 second(s) (analysis 194 ms, redo 1956 ms, undo 591 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s 0 transactions rolled back in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery is writing a checkpoint in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database ykgl (database ID 12) in 1 second(s) (analysis 59 ms, redo 80 ms, undo 723 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:41.43 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:41.43 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.12]
2014-08-21 08:40:42.16 spid27s 2771 transactions rolled forward in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s 0 transactions rolled back in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery is writing a checkpoint in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery completed for database chis (database ID 7) in 3 second(s) (analysis 2041 ms, redo 789 ms, undo 208 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s 1 transactions rolled back in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s Recovery is writing a checkpoint in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.37 spid6s Recovery completed for database mzsf (database ID 10) in 5 second(s) (analysis 60 ms, redo 1448 ms, undo 3997 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.60 spid35s 405 transactions rolled forward in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s 0 transactions rolled back in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery is writing a checkpoint in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery completed for database LSEMR (database ID 15) in 4 second(s) (analysis 1000 ms, redo 3302 ms, undo 474 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:46.62 spid33s 844 transactions rolled forward in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s 0 transactions rolled back in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery is writing a checkpoint in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery completed for database zygl (database ID 13) in 10 second(s) (analysis 2656 ms, redo 7270 ms, undo 445 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:47.39 spid6s Recovery is complete. This is an informational message only. No user action is required.
2014-08-21 08:40:48.49 spid54 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.51 spid54 Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.78 spid54 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.83 spid54 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.97 spid54 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.99 spid54 Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2014-08-21 09:57:40.56 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:57:40.60 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.04 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.23 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
#3
看了一下只有这个：Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 ，应该是某个库没启动，sa设置的默认数据库又指向这个库，所以登录失败
#4
这个数据库好像是 HIS系统的吧
用dbcc checkdb 检查一下ykgl
用dbcc checkdb 检查一下ykgl
#5
The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies
你的SQL VM域名注册肯定发生问题了。SQL重起不了。你们有域管理人员吗，询问下。
你的SQL VM域名注册肯定发生问题了。SQL重起不了。你们有域管理人员吗，询问下。
#6
我这边是完全内部网，SQL是装在VM sphere 虚拟机上的。之前实施的时候没听说了和域名有关的东西。
#7
出问题后想重启SQL 试试，但是配置管理器SQL服务看不见了。没办法就重启服务器了。重启后就正常了。
#8
sa不要指定数据库，直接用默认的master数据库，否则连接的时候，指定数据库要是没有启动，就会连接不上。
这个仅仅是开机的时候或者是删除指定数据库后使用sa连接。
你需要把出现问题的时候的日志发出来，而不是连接不上，重启服务器产生的日志。
这个仅仅是开机的时候或者是删除指定数据库后使用sa连接。
你需要把出现问题的时候的日志发出来，而不是连接不上，重启服务器产生的日志。
#9
这是北大医信(原方正众帮)的数据库
#1
14-08-21 08:40:35.76 spid24s Starting up database 'msdb'.
2014-08-21 08:40:35.76 spid25s Starting up database 'ReportServer'.
2014-08-21 08:40:35.76 spid26s Starting up database 'ReportServerTempDB'.
2014-08-21 08:40:35.76 spid27s Starting up database 'chis'.
2014-08-21 08:40:35.76 spid28s Starting up database 'cpdata'.
2014-08-21 08:40:35.76 spid29s Starting up database 'mpublic'.
2014-08-21 08:40:35.76 spid31s Starting up database 'yfgl'.
2014-08-21 08:40:35.76 spid32s Starting up database 'ykgl'.
2014-08-21 08:40:35.76 spid33s Starting up database 'zygl'.
2014-08-21 08:40:35.77 spid34s Starting up database 'zygl_bak'.
2014-08-21 08:40:35.77 spid35s Starting up database 'LSEMR'.
2014-08-21 08:40:35.77 spid36s Starting up database 'tjgl'.
2014-08-21 08:40:35.77 spid37s Starting up database 'yzcx'.
2014-08-21 08:40:35.77 spid30s Starting up database 'mzsf'.
2014-08-21 08:40:35.77 spid38s Starting up database 'BI'.
2014-08-21 08:40:35.77 spid39s Starting up database 'paul_His'.
2014-08-21 08:40:35.77 spid40s Starting up database 'MZSF_ERR'.
2014-08-21 08:40:35.77 spid41s Starting up database 'test03'.
2014-08-21 08:40:35.82 spid26s 1 transactions rolled forward in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s 0 transactions rolled back in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s Recovery is writing a checkpoint in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.90 spid28s 1 transactions rolled forward in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s 0 transactions rolled back in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s Recovery is writing a checkpoint in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.94 spid41s 1 transactions rolled forward in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.00 spid38s 1 transactions rolled forward in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s 0 transactions rolled back in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s Recovery is writing a checkpoint in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s 0 transactions rolled back in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s Recovery is writing a checkpoint in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.17 spid37s 1 transactions rolled forward in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s 0 transactions rolled back in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s Recovery is writing a checkpoint in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.94 spid29s 468 transactions rolled forward in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.04 spid6s 0 transactions rolled back in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.05 spid6s Recovery is writing a checkpoint in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.31 spid31s 3 transactions rolled forward in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.34 spid24s 391 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery completed for database msdb (database ID 4) in 1 second(s) (analysis 374 ms, redo 951 ms, undo 212 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s 0 transactions rolled back in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s Recovery is writing a checkpoint in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.81 spid34s 1 transactions rolled forward in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s 0 transactions rolled back in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s Recovery is writing a checkpoint in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:38.34 spid36s 1 transactions rolled forward in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.35 spid33s Recovery of database 'zygl' (13) is 5% complete (approximately 22 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:38.41 spid40s 1 transactions rolled forward in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s 0 transactions rolled back in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s Recovery is writing a checkpoint in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s 0 transactions rolled back in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s Recovery is writing a checkpoint in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:39.42 spid30s 296 transactions rolled forward in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:39.65 spid33s Recovery of database 'zygl' (13) is 11% complete (approximately 19 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:39.72 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:35.76 spid25s Starting up database 'ReportServer'.
2014-08-21 08:40:35.76 spid26s Starting up database 'ReportServerTempDB'.
2014-08-21 08:40:35.76 spid27s Starting up database 'chis'.
2014-08-21 08:40:35.76 spid28s Starting up database 'cpdata'.
2014-08-21 08:40:35.76 spid29s Starting up database 'mpublic'.
2014-08-21 08:40:35.76 spid31s Starting up database 'yfgl'.
2014-08-21 08:40:35.76 spid32s Starting up database 'ykgl'.
2014-08-21 08:40:35.76 spid33s Starting up database 'zygl'.
2014-08-21 08:40:35.77 spid34s Starting up database 'zygl_bak'.
2014-08-21 08:40:35.77 spid35s Starting up database 'LSEMR'.
2014-08-21 08:40:35.77 spid36s Starting up database 'tjgl'.
2014-08-21 08:40:35.77 spid37s Starting up database 'yzcx'.
2014-08-21 08:40:35.77 spid30s Starting up database 'mzsf'.
2014-08-21 08:40:35.77 spid38s Starting up database 'BI'.
2014-08-21 08:40:35.77 spid39s Starting up database 'paul_His'.
2014-08-21 08:40:35.77 spid40s Starting up database 'MZSF_ERR'.
2014-08-21 08:40:35.77 spid41s Starting up database 'test03'.
2014-08-21 08:40:35.82 spid26s 1 transactions rolled forward in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s 0 transactions rolled back in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.86 spid6s Recovery is writing a checkpoint in database 'ReportServerTempDB' (6). This is an informational message only. No user action is required.
2014-08-21 08:40:35.90 spid28s 1 transactions rolled forward in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s 0 transactions rolled back in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.93 spid26s Recovery is writing a checkpoint in database 'cpdata' (8). This is an informational message only. No user action is required.
2014-08-21 08:40:35.94 spid41s 1 transactions rolled forward in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.00 spid38s 1 transactions rolled forward in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s 0 transactions rolled back in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.03 spid6s Recovery is writing a checkpoint in database 'test03' (22). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s 0 transactions rolled back in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.05 spid41s Recovery is writing a checkpoint in database 'BI' (18). This is an informational message only. No user action is required.
2014-08-21 08:40:36.17 spid37s 1 transactions rolled forward in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s 0 transactions rolled back in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.32 spid25s Recovery is writing a checkpoint in database 'yzcx' (17). This is an informational message only. No user action is required.
2014-08-21 08:40:36.94 spid29s 468 transactions rolled forward in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.04 spid6s 0 transactions rolled back in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.05 spid6s Recovery is writing a checkpoint in database 'mpublic' (9). This is an informational message only. No user action is required.
2014-08-21 08:40:37.31 spid31s 3 transactions rolled forward in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.34 spid24s 391 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2014-08-21 08:40:37.55 spid6s Recovery completed for database msdb (database ID 4) in 1 second(s) (analysis 374 ms, redo 951 ms, undo 212 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s 0 transactions rolled back in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.76 spid6s Recovery is writing a checkpoint in database 'yfgl' (11). This is an informational message only. No user action is required.
2014-08-21 08:40:37.81 spid34s 1 transactions rolled forward in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s 0 transactions rolled back in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:37.86 spid6s Recovery is writing a checkpoint in database 'zygl_bak' (14). This is an informational message only. No user action is required.
2014-08-21 08:40:38.34 spid36s 1 transactions rolled forward in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.35 spid33s Recovery of database 'zygl' (13) is 5% complete (approximately 22 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:38.41 spid40s 1 transactions rolled forward in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s 0 transactions rolled back in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.54 spid6s Recovery is writing a checkpoint in database 'MZSF_ERR' (20). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s 0 transactions rolled back in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:38.91 spid6s Recovery is writing a checkpoint in database 'tjgl' (16). This is an informational message only. No user action is required.
2014-08-21 08:40:39.42 spid30s 296 transactions rolled forward in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:39.65 spid33s Recovery of database 'zygl' (13) is 11% complete (approximately 19 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-08-21 08:40:39.72 登录 错误: 18456，严重性: 14，状态: 38。
#2
2014-08-21 08:40:39.72 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.3]
2014-08-21 08:40:39.76 spid32s 2 transactions rolled forward in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:39.90 spid39s 841 transactions rolled forward in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s 0 transactions rolled back in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s Recovery is writing a checkpoint in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database paul_His (database ID 19) in 2 second(s) (analysis 194 ms, redo 1956 ms, undo 591 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s 0 transactions rolled back in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery is writing a checkpoint in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database ykgl (database ID 12) in 1 second(s) (analysis 59 ms, redo 80 ms, undo 723 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:41.43 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:41.43 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.12]
2014-08-21 08:40:42.16 spid27s 2771 transactions rolled forward in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s 0 transactions rolled back in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery is writing a checkpoint in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery completed for database chis (database ID 7) in 3 second(s) (analysis 2041 ms, redo 789 ms, undo 208 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s 1 transactions rolled back in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s Recovery is writing a checkpoint in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.37 spid6s Recovery completed for database mzsf (database ID 10) in 5 second(s) (analysis 60 ms, redo 1448 ms, undo 3997 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.60 spid35s 405 transactions rolled forward in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s 0 transactions rolled back in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery is writing a checkpoint in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery completed for database LSEMR (database ID 15) in 4 second(s) (analysis 1000 ms, redo 3302 ms, undo 474 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:46.62 spid33s 844 transactions rolled forward in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s 0 transactions rolled back in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery is writing a checkpoint in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery completed for database zygl (database ID 13) in 10 second(s) (analysis 2656 ms, redo 7270 ms, undo 445 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:47.39 spid6s Recovery is complete. This is an informational message only. No user action is required.
2014-08-21 08:40:48.49 spid54 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.51 spid54 Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.78 spid54 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.83 spid54 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.97 spid54 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.99 spid54 Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2014-08-21 09:57:40.56 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:57:40.60 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.04 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.23 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 08:40:39.76 spid32s 2 transactions rolled forward in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:39.90 spid39s 841 transactions rolled forward in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s 0 transactions rolled back in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.50 spid39s Recovery is writing a checkpoint in database 'paul_His' (19). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database paul_His (database ID 19) in 2 second(s) (analysis 194 ms, redo 1956 ms, undo 591 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s 0 transactions rolled back in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery is writing a checkpoint in database 'ykgl' (12). This is an informational message only. No user action is required.
2014-08-21 08:40:40.69 spid39s Recovery completed for database ykgl (database ID 12) in 1 second(s) (analysis 59 ms, redo 80 ms, undo 723 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:41.43 登录 错误: 18456，严重性: 14，状态: 38。
2014-08-21 08:40:41.43 登录 Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.12]
2014-08-21 08:40:42.16 spid27s 2771 transactions rolled forward in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s 0 transactions rolled back in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery is writing a checkpoint in database 'chis' (7). This is an informational message only. No user action is required.
2014-08-21 08:40:42.38 spid27s Recovery completed for database chis (database ID 7) in 3 second(s) (analysis 2041 ms, redo 789 ms, undo 208 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s 1 transactions rolled back in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.26 spid6s Recovery is writing a checkpoint in database 'mzsf' (10). This is an informational message only. No user action is required.
2014-08-21 08:40:43.37 spid6s Recovery completed for database mzsf (database ID 10) in 5 second(s) (analysis 60 ms, redo 1448 ms, undo 3997 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:43.60 spid35s 405 transactions rolled forward in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s 0 transactions rolled back in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery is writing a checkpoint in database 'LSEMR' (15). This is an informational message only. No user action is required.
2014-08-21 08:40:44.08 spid6s Recovery completed for database LSEMR (database ID 15) in 4 second(s) (analysis 1000 ms, redo 3302 ms, undo 474 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:46.62 spid33s 844 transactions rolled forward in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s 0 transactions rolled back in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery is writing a checkpoint in database 'zygl' (13). This is an informational message only. No user action is required.
2014-08-21 08:40:47.10 spid6s Recovery completed for database zygl (database ID 13) in 10 second(s) (analysis 2656 ms, redo 7270 ms, undo 445 ms.) This is an informational message only. No user action is required.
2014-08-21 08:40:47.39 spid6s Recovery is complete. This is an informational message only. No user action is required.
2014-08-21 08:40:48.49 spid54 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.51 spid54 Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.78 spid54 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.83 spid54 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2014-08-21 08:40:48.97 spid54 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2014-08-21 08:40:48.99 spid54 Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2014-08-21 09:57:40.56 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:57:40.60 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.04 spid175 DBCC TRACEON 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
2014-08-21 09:58:04.23 spid175 DBCC TRACEOFF 3604, server process ID (SPID) 175. This is an informational message only; no user action is required.
#3
看了一下只有这个：Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 ，应该是某个库没启动，sa设置的默认数据库又指向这个库，所以登录失败
#4
这个数据库好像是 HIS系统的吧
用dbcc checkdb 检查一下ykgl
用dbcc checkdb 检查一下ykgl
#5
The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies
你的SQL VM域名注册肯定发生问题了。SQL重起不了。你们有域管理人员吗，询问下。
你的SQL VM域名注册肯定发生问题了。SQL重起不了。你们有域管理人员吗，询问下。
#6
我这边是完全内部网，SQL是装在VM sphere 虚拟机上的。之前实施的时候没听说了和域名有关的东西。
#7
出问题后想重启SQL 试试，但是配置管理器SQL服务看不见了。没办法就重启服务器了。重启后就正常了。
#8
sa不要指定数据库，直接用默认的master数据库，否则连接的时候，指定数据库要是没有启动，就会连接不上。
这个仅仅是开机的时候或者是删除指定数据库后使用sa连接。
你需要把出现问题的时候的日志发出来，而不是连接不上，重启服务器产生的日志。
这个仅仅是开机的时候或者是删除指定数据库后使用sa连接。
你需要把出现问题的时候的日志发出来，而不是连接不上，重启服务器产生的日志。
#9
这是北大医信(原方正众帮)的数据库