今天突然发现 sql服务无法启动了 急啊 求解,错误日志如下 :2010-06-03 10:06:24.04 server Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)
Dec 16 2008 19:46:53
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)2010-06-03 10:06:24.04 server Copyright (C) 1988-2002 Microsoft Corporation.
2010-06-03 10:06:24.04 server 保留所有权利。
2010-06-03 10:06:24.04 server 服务器进程 ID 是 5248。
2010-06-03 10:06:24.04 server 将 SQL Server 消息记录在文件“C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG”中。
2010-06-03 10:06:24.04 server SQL Server 正在以优先级“normal”(已检测到 2 CPUs)启动。
2010-06-03 10:06:24.64 server 已为 thread 模式处理而配置了 SQL Server。
2010-06-03 10:06:24.65 server 使用 dynamic 锁分配。[2500] 锁块,[5000] 锁所有者块。
2010-06-03 10:06:24.65 server 尝试初始化分布式事务处理协调器。
2010-06-03 10:06:24.68 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
2010-06-03 10:06:24.68 spid3 启动数据库“master”。
2010-06-03 10:06:24.68 spid3 udopen: 创建/打开物理设备 C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf 时发生操作系统错误 2(系统找不到指定的文件。)。
2010-06-03 10:06:24.68 spid3 FCB::Open failed: 未能为虚拟设备号 (VDN) 2 打开设备 C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf。
2010-06-03 10:06:24.68 spid3 错误: 5105,严重度: 16,状态: 4。
2010-06-03 10:06:24.70 spid3 06/03/10 10:06:24 Stack Overflow Dump not possible - Exception c00000fd E at 0x0041E4AC
2010-06-03 10:06:24.70 spid3 Address=41e4ac Exception Code = c00000fd
2010-06-03 10:06:24.70 spid3 eax=03fc3758 ebx=00000000 ecx=1a64cb68 edx=1a634000
2010-06-03 10:06:24.70 spid3 esi=1a64cb68 edi=00000000 eip=0041e4ac esp=03fc2ec0
2010-06-03 10:06:24.70 spid3 ebp=03fc3730 efl=00010206
2010-06-03 10:06:24.70 spid3 cs=1b ss=23 ds=23 es=23 fs=3b gs=0
2010-06-03 10:06:24.70 spid3 1: Frame: 03FC3730 Return Address 0041E4AC
2010-06-03 10:06:24.70 spid3 2: Frame: 03FC37A8 Return Address 00405E5E
2010-06-03 10:06:24.70 spid3 3: Frame: 03FC383C Return Address 0040602A
2010-06-03 10:06:24.70 spid3 4: Frame: 03FC38B8 Return Address 0040609D
2010-06-03 10:06:24.70 spid3 5: Frame: 03FC390C Return Address 004062C3
2010-06-03 10:06:24.70 spid3 6: Frame: 03FC3964 Return Address 00405B60
2010-06-03 10:06:24.70 spid3 7: Frame: 03FC39B4 Return Address 00409802
2010-06-03 10:06:24.70 spid3 8: Frame: 03FC39CC Return Address 0040993E
2010-06-03 10:06:24.70 spid3 9: Frame: 03FC3A34 Return Address 004628FA
2010-06-03 10:06:24.70 spid3 10: Frame: 03FC3EC4 Return Address 004AFB36
2010-06-03 10:06:24.70 spid3 11: Frame: 03FC3F18 Return Address 004052E7
2010-06-03 10:06:24.70 spid3 12: Frame: 03FC3F40 Return Address 00409BF9
2010-06-03 10:06:24.70 spid3 13: Frame: 03FC3F6C Return Address 00409C2F
2010-06-03 10:06:24.70 spid3 14: Frame: 03FC3F94 Return Address 00409894
2010-06-03 10:06:24.70 spid3 15: Frame: 03FC3FFC Return Address 004A2376
2010-06-03 10:06:24.70 spid3 16: Frame: 03FC4820 Return Address 006D0A0D
2010-06-03 10:06:24.70 spid3 17: Frame: 03FC4834 Return Address 0044B3A0
2010-06-03 10:06:24.70 spid3 18: Frame: 03FC4844 Return Address 0044B3D2
2010-06-03 10:06:24.70 spid3 19: Frame: 03FC4890 Return Address 0044B3F0
2010-06-03 10:06:24.70 spid3 20: Frame: 03FC48B0 Return Address 0050EBC0
2010-06-03 10:06:24.70 spid3
2010-06-03 10:06:24.70 spid3 TotalPhysicalMemory = 2137174016, AvailablePhysicalMemory = 1057181696
2010-06-03 10:06:24.70 spid3 AvailableVirtualMemory = 374554624, AvailablePagingFile = 3047661568
Dec 16 2008 19:46:53
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)2010-06-03 10:06:24.04 server Copyright (C) 1988-2002 Microsoft Corporation.
2010-06-03 10:06:24.04 server 保留所有权利。
2010-06-03 10:06:24.04 server 服务器进程 ID 是 5248。
2010-06-03 10:06:24.04 server 将 SQL Server 消息记录在文件“C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG”中。
2010-06-03 10:06:24.04 server SQL Server 正在以优先级“normal”(已检测到 2 CPUs)启动。
2010-06-03 10:06:24.64 server 已为 thread 模式处理而配置了 SQL Server。
2010-06-03 10:06:24.65 server 使用 dynamic 锁分配。[2500] 锁块,[5000] 锁所有者块。
2010-06-03 10:06:24.65 server 尝试初始化分布式事务处理协调器。
2010-06-03 10:06:24.68 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
2010-06-03 10:06:24.68 spid3 启动数据库“master”。
2010-06-03 10:06:24.68 spid3 udopen: 创建/打开物理设备 C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf 时发生操作系统错误 2(系统找不到指定的文件。)。
2010-06-03 10:06:24.68 spid3 FCB::Open failed: 未能为虚拟设备号 (VDN) 2 打开设备 C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf。
2010-06-03 10:06:24.68 spid3 错误: 5105,严重度: 16,状态: 4。
2010-06-03 10:06:24.70 spid3 06/03/10 10:06:24 Stack Overflow Dump not possible - Exception c00000fd E at 0x0041E4AC
2010-06-03 10:06:24.70 spid3 Address=41e4ac Exception Code = c00000fd
2010-06-03 10:06:24.70 spid3 eax=03fc3758 ebx=00000000 ecx=1a64cb68 edx=1a634000
2010-06-03 10:06:24.70 spid3 esi=1a64cb68 edi=00000000 eip=0041e4ac esp=03fc2ec0
2010-06-03 10:06:24.70 spid3 ebp=03fc3730 efl=00010206
2010-06-03 10:06:24.70 spid3 cs=1b ss=23 ds=23 es=23 fs=3b gs=0
2010-06-03 10:06:24.70 spid3 1: Frame: 03FC3730 Return Address 0041E4AC
2010-06-03 10:06:24.70 spid3 2: Frame: 03FC37A8 Return Address 00405E5E
2010-06-03 10:06:24.70 spid3 3: Frame: 03FC383C Return Address 0040602A
2010-06-03 10:06:24.70 spid3 4: Frame: 03FC38B8 Return Address 0040609D
2010-06-03 10:06:24.70 spid3 5: Frame: 03FC390C Return Address 004062C3
2010-06-03 10:06:24.70 spid3 6: Frame: 03FC3964 Return Address 00405B60
2010-06-03 10:06:24.70 spid3 7: Frame: 03FC39B4 Return Address 00409802
2010-06-03 10:06:24.70 spid3 8: Frame: 03FC39CC Return Address 0040993E
2010-06-03 10:06:24.70 spid3 9: Frame: 03FC3A34 Return Address 004628FA
2010-06-03 10:06:24.70 spid3 10: Frame: 03FC3EC4 Return Address 004AFB36
2010-06-03 10:06:24.70 spid3 11: Frame: 03FC3F18 Return Address 004052E7
2010-06-03 10:06:24.70 spid3 12: Frame: 03FC3F40 Return Address 00409BF9
2010-06-03 10:06:24.70 spid3 13: Frame: 03FC3F6C Return Address 00409C2F
2010-06-03 10:06:24.70 spid3 14: Frame: 03FC3F94 Return Address 00409894
2010-06-03 10:06:24.70 spid3 15: Frame: 03FC3FFC Return Address 004A2376
2010-06-03 10:06:24.70 spid3 16: Frame: 03FC4820 Return Address 006D0A0D
2010-06-03 10:06:24.70 spid3 17: Frame: 03FC4834 Return Address 0044B3A0
2010-06-03 10:06:24.70 spid3 18: Frame: 03FC4844 Return Address 0044B3D2
2010-06-03 10:06:24.70 spid3 19: Frame: 03FC4890 Return Address 0044B3F0
2010-06-03 10:06:24.70 spid3 20: Frame: 03FC48B0 Return Address 0050EBC0
2010-06-03 10:06:24.70 spid3
2010-06-03 10:06:24.70 spid3 TotalPhysicalMemory = 2137174016, AvailablePhysicalMemory = 1057181696
2010-06-03 10:06:24.70 spid3 AvailableVirtualMemory = 374554624, AvailablePagingFile = 3047661568
找到提示的路径,看一下是否移动过那个文件
--------------------------------------------------
SQL Server 找不到 master 数据库的日志文件(mastlog.ldf)。检查此文件是否在 C:\Program Files\Microsoft SQL Server\MSSQL\data\ 目录下。如果没有,则需要使用内置的 rebuildm.exe 工具重建 MASTER 数据库,再还原 MASTER、MSDB、MODEL、DISTRIBUTION、用户数据库。
http://msdn.microsoft.com/en-us/library/aa197950%28SQL.80%29.aspx