日期:2014-05-18  浏览次数:20901 次

sqlserver2008错误17054
今天早上突然就报的错,服务启动不起来。日志如下:

2011-06-03 09:18:04.78 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) 
Mar 29 2009 10:27:29 
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

2011-06-03 09:18:05.03 Server Error: 17054, Severity: 16, State: 1.
2011-06-03 09:18:05.03 Server The current event was not reported to the Windows Events log. Operating system error = 1502(事件日志文件已满。). You may need to clear the Windows Events log if it is full.
2011-06-03 09:18:05.09 Server (c) 2005 Microsoft Corporation.
2011-06-03 09:18:05.10 Server All rights reserved.
2011-06-03 09:18:05.10 Server Server process ID is 376.
2011-06-03 09:18:05.12 Server Authentication mode is WINDOWS-ONLY.
2011-06-03 09:18:05.15 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2011-06-03 09:18:05.34 Server This instance of SQL Server last reported using a process ID of 1628 at 2011-6-3 9:17:07 (local) 2011-6-3 1:17:07 (UTC). This is an informational message only; no user action is required.
2011-06-03 09:18:05.35 Server Registry startup parameters: 
-d C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2011-06-03 09:18:05.59 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-06-03 09:18:05.62 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2011-06-03 09:18:08.89 服务器 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.
2011-06-03 09:18:12.21 服务器 Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-06-03 09:18:14.93 spid7s Starting up database 'master'.
2011-06-03 09:18:16.69 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-06-03 09:18:18.91 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
2011-06-03 09:18:19.94 spid7s SQL Trace ID 1 was started by login "sa".
2011-06-03 09:18:20.13 spid7s Starting up database 'mssqlsystemresource'.
2011-06-03 09:18:20.20 spid7s The resource database build version is 10.00.2531. This is an informational message only. No user action is required.
2011-06-03 09:18:21.04 spid10s Starting up database 'model'.
2011-06-03 09:18:21.06 spid7s Server name is 'IT_LFH\SQLEXPRESS'. This is an informational message only. No user action is required.
2011-06-03 09:18:21.26 spid7s 信息: 找不到支持全文的语言。
2011-06-03 09:18:21.30 spid7s Starting up database 'msdb'.
2011-06-03 09:18:21.96 spid10s Clearing tempdb database.
2011-06-03 09:18:22.02 服务器 A self-generated certificate was successfully loaded for encryption.
2011-06-03 09:18:22.05 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2011-06-03 09:18:22.05 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
2011-06-03 09:18:22.06 服务器 Dedicated administrator connection support was not started because it