2014-12-11 03:25:12.78 Server Microsoft SQL Server 2005 - 9.00.5000.00 (X64)
Dec 10 2010 10:38:40
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
2014-12-11 03:25:12.90 Server (c) 2005 Microsoft Corporation.
2014-12-11 03:25:12.90 Server All rights reserved.
2014-12-11 03:25:12.90 Server Server process ID is 1260.
2014-12-11 03:25:12.90 Server Authentication mode is MIXED.
2014-12-11 03:25:12.90 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2014-12-11 03:25:12.90 Server This instance of SQL Server last reported using a process ID of 1240 at 2014/12/11 3:22:38 (local) 2014/12/10 19:22:38 (UTC). This is an informational message only; no user action is required.
2014-12-11 03:25:12.90 Server Registry startup parameters:
2014-12-11 03:25:12.94 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2014-12-11 03:25:12.94 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2014-12-11 03:25:12.94 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2014-12-11 03:25:13.01 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2014-12-11 03:25:13.01 服务器 Detected 16 CPUs. This is an informational message; no user action is required.
2014-12-11 03:25:13.27 Server Large Page Extensions enabled.
2014-12-11 03:25:13.27 Server Large Page Granularity: 2097152
2014-12-11 03:25:13.30 Server Large Page Allocated: 32MB
2014-12-11 03:25:13.46 Server Large Page Allocated: 32MB
2014-12-11 03:25:13.76 服务器 Using locked pages for buffer pool.
2014-12-11 03:25:14.24 服务器 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-12-11 03:25:14.25 服务器 Lock partitioning is enabled. This is an informational message only. No user action is required.
2014-12-11 03:25:14.58 服务器 Multinode configuration: node 0: CPU mask: 0x000000000000ff00 Active CPU mask: 0x000000000000ff00. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2014-12-11 03:25:14.58 服务器 Multinode configuration: node 1: CPU mask: 0x00000000000000ff Active CPU mask: 0x00000000000000ff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2014-12-11 03:25:14.58 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2014-12-11 03:25:14.66 服务器 The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2014-12-11 03:25:14.75 服务器 Database mirroring has been enabled on this instance of SQL Server.
2014-12-11 03:25:14.95 spid7s Starting up database 'master'.
2014-12-11 03:25:15.49 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2014-12-11 03:25:15.81 spid7s SQL Trace ID 1 was started by login "sa".
2014-12-11 03:25:15.86 spid7s Starting up database 'mssqlsystemresource'.
2014-12-11 03:25:15.88 spid7s The resource database build version is 9.00.5000. This is an informational message only. No user action is required.
2014-12-11 03:25:16.20 spid11s Starting up database 'model'.
2014-12-11 03:25:16.22 spid7s Server name is 'YXT-YY02'. This is an informational message only. No user action is required.
2014-12-11 03:25:16.36 spid11s Clearing tempdb database.
2014-12-11 03:25:16.69 服务器 A self-generated certificate was successfully loaded for encryption.
2014-12-11 03:25:16.69 服务器 Server is listening on [ 'any' <ipv6> 1433].
2014-12-11 03:25:16.69 服务器 Server is listening on [ 'any' <ipv4> 1433].
2014-12-11 03:25:16.69 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2014-12-11 03:25:16.69 服务器 Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2014-12-11 03:25:16.70 服务器 Server is listening on [ ::1 <ipv6> 1434].
2014-12-11 03:25:16.70 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2014-12-11 03:25:16.70 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2014-12-11 03:25:16.71 服务器 The SQL 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-12-11 03:25:16.72 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2014-12-11 03:25:17.83 spid11s Starting up database 'tempdb'.
2014-12-11 03:25:18.98 spid14s The Service Broker protocol transport is disabled or not configured.
2014-12-11 03:25:18.98 spid14s The Database Mirroring protocol transport is disabled or not configured.
2014-12-11 03:25:19.93 spid14s Service Broker manager has started.
2014-12-11 03:25:20.25 spid23s Starting up database 'jxpt_jx_addins'.
2014-12-11 03:25:20.26 spid22s Starting up database 'msdb'.
2014-12-11 03:25:20.26 spid23s 错误: 17207，严重性: 16，状态: 1。
2014-12-11 03:25:20.26 spid23s FCB::Open: Operating system error 3(系统找不到指定的路径。) occurred while creating or opening file 'D:\database\jxpt_jx_addins.mdf'. Diagnose and correct the operating system error, and retry the operation.
2014-12-11 03:25:20.28 spid23s 错误: 17204，严重性: 16，状态: 1。
2014-12-11 03:25:20.28 spid23s FCB::Open failed: Could not open file D:\database\jxpt_jx_addins.mdf for file number 1. OS error: 3(系统找不到指定的路径。).
2014-12-11 03:25:20.39 spid23s 错误: 5120，严重性: 16，状态: 101。
2014-12-11 03:25:20.39 spid23s 无法打开物理文件 "D:\database\jxpt_jx_addins.mdf"。操作系统错误 3:"3(系统找不到指定的路径。)"。
2014-12-11 03:25:20.72 spid23s 错误: 17207，严重性: 16，状态: 1。
2014-12-11 03:25:20.72 spid23s FileMgr::StartLogFiles: Operating system error 2(系统找不到指定的文件。) occurred while creating or opening file 'D:\database\jxpt_jx_addins_log.ldf'. Diagnose and correct the operating system error, and retry the operation.
2014-12-11 03:25:20.74 spid23s 文件激活失败。物理文件名称'D:\database\jxpt_jx_addins_log.ldf'可能不正确。
2014-12-11 03:25:20.81 spid7s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2014-12-11 03:25:20.91 spid7s Recovery is complete. This is an informational message only. No user action is required.
2014-12-11 03:25:23.19 spid51 Using 'xpsqlbot.dll' version '2005.90.5000' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2014-12-11 03:25:23.60 spid51 Using 'xpstar90.dll' version '2005.90.5000' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2014-12-11 03:25:23.73 spid51 Using 'xplog70.dll' version '2005.90.5000' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
错误日志如上， 反正数据库是访问不了， 但重启服务之后就可以的了……
------解决思路----------------------
dbcc检查一下你的数据库jxpt_jx_addins，不太清楚是什么问题
------解决思路----------------------
dbcc checkdb
------解决思路----------------------
忘了在哪里看过的，实时：
2007-07-03 10:51:58.48 spid5s FCB::Open: Operating system error 3(系统找不到指定的路径。) occurred while creating or opening file 'I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf'. Diagnose and correct the operating system error, and retry the operation.
2007-07-03 10:51:58.48 spid5s 错误: 17204，严重性: 16，状态: 1。
2007-07-03 10:51:58.48 spid5s FCB::Open failed: Could not open file I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf for file number 1. OS error: 3(系统找不到指定的路径。).
2007-07-03 10:51:58.48 spid5s 错误: 5120，严重性: 16，状态: 101。
2007-07-03 10:51:58.48 spid5s 无法打开物理文件 "I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf"。操作系统错误 3:"3(系统找不到指定的路径。)"。
2007-07-03 10:51:58.48 spid5s 错误: 17207，严重性: 16，状态: 1。
2007-07-03 10:51:58.48 spid5s FileMgr::StartLogFiles: Operating system error 2(系统找不到指定的文件。) occurred while creating or opening file 'I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.
2007-07-03 10:51:58.48 spid5s 文件激活失败。物理文件名称'I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf'可能不正确。
Resource 数据库依赖于 master 数据库的位置。如果移动了 master 数据库，则必须也将 Resource 数据库移动到相同的位置。有关详细信息，请参阅移动系统数据库。另外，请勿将 Resource 数据库放置在压缩或加密的 NTFS 文件系统文件夹中。此操作会降低性能并阻止升级
版本一样的替换就行， 这个放的是系统存储过程之类的东东， 相同的版本都是相同的，估计是装 service package， 或者系统补丁， 有些东西要重启才生效，而且控制得有问题，所以重启后要让某些东西生效，但是这个东东被删除了没有恢复
http://connect.microsoft.com/SQLServer/feedback/details/689665/mssqlsystemresource-database-is-removed-after-sql-server-2008-r2-sp1-installation