SQL Server 2008 R2将不会启动 – 超时

我不能再启动或停止SQL Express。这只发生在安装SQLpipe理工作室之后。其中一个参数告诉我，它不在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: -dc:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf -ec:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG -lc:\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.

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

 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期待的地方。文件是移动还是被删除？

你可以在你的服务器上searchmaster.mdf吗？

如果find它，请将其复制回错误日志中列出的path，或更新SQL Serverconfigurationpipe理器以指向正确的位置。

一旦你解决了这个错误，你也可能在master.ldf上收到一个错误。解决scheme将是相同的。

然后，你可能不得不处理tempdb ， model和msdb 。那些可以用类似的方式解决。

当你遇到这些问题时，另一个需要探索的就是从命令行开始使用跟踪标志3608的SQL。这将允许你一次一个地更正每个数据库。

这里有一些链接：

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

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

先照顾好主人，然后让我们知道剩下的事情。

祝你好运！