我已经安装了SQL SERVER 2005 sp3,当我尝试启动它时,出现以下错误
从SQL Server错误日志:
2010-12-12 01:05:54.40 Server Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 2010-12-12 01:05:54.40 Server (c) 2005 Microsoft Corporation. 2010-12-12 01:05:54.40 Server All rights reserved. 2010-12-12 01:05:54.40 Server Server process ID is 3028. 2010-12-12 01:05:54.40 Server Authentication mode is MIXED. 2010-12-12 01:05:54.40 Server Logging SQL Server messages in file 'F:\sql-log\ERRORLOG'. 2010-12-12 01:05:54.40 Server This instance of SQL Server last reported using a process ID of 1576 at 2010-12-12 1:03:14 (local) 2010-12-11 17:03:14 (UTC). This is an informational message only; no user action is required. 2010-12-12 01:05:54.40 Server Registry startup parameters: -d C:\master.mdf -e F:\sql-log\ERRORLOG -e F:\sql-log\ERRORLOG SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. Detected 8 CPUs. This is an informational message; no user action is required. Set AWE Enabled to 1 in the configuration parameters to allow use of more memory. 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. Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. Database mirroring has been enabled on this instance of SQL Server. Starting up database 'master'. error: 17207,severity: 16,state: 1。 **FCB::Open: Operating system error 3(file not found.) occurred while creating or opening file ''. Diagnose and correct the operating system error, and retry the operation.** Error: 17204, Severity: 16, State: 1. **FCB::Open failed: Could not open file for file number 2. OS error: 3(file not found.).** Error: 5120, Severity: 16, State: 101. **unable to open the physical file ""。Operating system error 3:"3(file not found.)"。**
为什么文件名是空的?
它应该是“c:\ master.mdf”
似乎是同样的问题。 如何改变正确的path? 谢谢
看起来像是在SQL Serverconfiguration中发生了变化。 错误日志读取
-d C:\ master.mdf
-e F:\ sql-log \ ERRORLOG
-e F:\ sql-log \ ERRORLOG
代表主数据库日志文件的-l参数缺失。 请启动SQL Serverconfigurationpipe理器并更改SQL Server服务的启动参数。 更多信息在这里
以下是解决此问题的步骤。