SQL Server 2008 R2 无法启动 - 超时

SQL Server 2008 R2 无法启动 - 超时

我无法再启动或停止 SQL Express。这只是在前几天安装 SQL Management Studio 之后发生的。其中一个参数告诉我它不在 64 位操作系统下运行。- 是的!

我能做些什么?

这是日志文件报告:

2012-10-30 10:47:27.09 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) 
    Apr 22 2011 19:23:43 
    Copyright (c) Microsoft Corporation
    Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2012-10-30 10:47:27.09 Server      (c) Microsoft Corporation.
2012-10-30 10:47:27.09 Server      All rights reserved.
2012-10-30 10:47:27.09 Server      Server process ID is 5028.
2012-10-30 10:47:27.09 Server      System Manufacturer: 'Gigabyte Technology Co., Ltd.', System Model: 'GA-880GM-USB3'.
2012-10-30 10:47:27.09 Server      Authentication mode is MIXED.
2012-10-30 10:47:27.09 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2012-10-30 10:47:27.09 Server      This instance of SQL Server last reported using a process ID of 3688 at 30/10/2012 10:46:25 (local) 30/10/2012 10:46:25 (UTC). This is an informational message only; no user action is required.
2012-10-30 10:47:27.09 Server      Registry startup parameters: 
     -d c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf
     -e c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG
     -l c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2012-10-30 10:47:27.09 Server      Error: 17113, Severity: 16, State: 1.
2012-10-30 10:47:27.09 Server      Error 2(failed to retrieve text for this error. Reason: 15100) occurred while opening file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

答案1

根据错误日志中的这一行:

2012-10-30 10:47:27.09 Server      Error 2(failed to retrieve text for this error. Reason: 15100) occurred while opening file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf' 

这意味着主数据库不再位于 SQL Server 期望的位置。文件是否被移动或删除?

你能搜索一下主文件在你的服务器上?

如果找到它,请将其复制回错误日志中列出的路径,或更新 SQL Server 配置管理器以指向正确的位置。

修复此错误后,您可能还会收到 master.ldf 上的错误。解决方案相同。

然后,你可能需要处理临时数据库模型, 和数据库. 这些问题可以用类似的方式解决。

当您了解这些之后,要探索的另一件事是从带有跟踪标志 3608 的命令行启动 SQL。这将允许您一次更正一个数据库。

以下是一些链接:

http://msdn.microsoft.com/en-us/library/ms180965(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms188396.aspx

先照顾好主人,然后再告诉我们其余的事情进展如何。

祝你好运!

相关内容