Sql Server 2005的问题
今天手动启动本机的sqlserver2005实例,突然失败了,昨天还好好的,看了log,内容如下:
2007-07-03 10:51:58.00 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-07-03 10:51:58.00 Server (c) 2005 Microsoft Corporation.
2007-07-03 10:51:58.00 Server All rights reserved.
2007-07-03 10:51:58.00 Server Server process ID is 3580.
2007-07-03 10:51:58.00 Server Logging SQL Server messages in file 'J:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG '.
2007-07-03 10:51:58.00 Server This instance of SQL Server last reported using a process ID of 3060 at 2007-7-3 10:44:34 (local) 2007-7-3 2:44:34 (UTC). This is an informational message only; no user action is required.
2007-07-03 10:51:58.00 Server Registry startup parameters:
2007-07-03 10:51:58.00 Server -d J:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-07-03 10:51:58.00 Server -e J:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-07-03 10:51:58.00 Server -l J:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-07-03 10:51:58.01 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-07-03 10:51:58.01 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2007-07-03 10:51:58.28 服务器 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.
2007-07-03 10:51:58.29 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-07-03 10:51:58.32 服务器 The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2007-07-03 10:51:58.32 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2007-07-03 10:51:58.34 spid5s Starting up database 'master '.
2007-07-03 10:51:58.45 spid5s SQL Trace ID 1 was started by login "sa ".
2007-07-03 10:51:58.48 spid5s Starting up database 'mssqlsystemresource '.
2007-07-03 10:51:58.48 spid5s 错误: 17207,严重性: 16,状态: 1。
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 '可能不正确。
2007-07-03 10:51:58.48 spid5s 错误: 945,严重性: 14,状态: 2。
2007-07-03 10:51:58.48 spid5s 由于文件不可访问,或者内存或磁盘空间不足,所以无法打开数据库 'mssqlsystemresource '。有关详细信息,请参阅 SQL Server 错误日志。
2007-07-03 10:51:58.48 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1 '. This is an informational message only; no user action is required.
我的sqlserver2005确确实实是安装在J盘的,以前一直正常,无论是自动还是手动启动,为什么今天的启动突然倒I盘去找mssqlsystemresource库,我在configuration manager里面看sql服务的启动参数,也没发现要启动mssqlsystemresource库,有些弄不明白,请高手指教.
我机器上的mssqlsystemresource库物理文件位于J盘的sqlserver对应的data目录下,这个库有何用,是启动之必须吗?
[解决办法]
刚才查了一下, 这个应该和master在一齐才对啊. 但楼主的启动参数显示maste在J盘启动, 有点没有搞懂.
楼主试试将 J:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ 下的东西全部复制到 I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
再在sql配置管理器中将启动参数改为从I盘启动试试