当我收缩数据库时,机器被重新启动,从那时起,SQL Server (MSSQLSERVER)就不启动了。在阅读了博客之后,我用相同的文件替换了templates文件夹中的master.mdf和mastlog.ldf文件,假设主数据库在我收缩它时已经损坏了。
但是,问题仍然存在,错误日志文件显示以下消息:
Starting up database 'msdb'.
Starting up database 'mssqlsystemresource'.
Error: 17204, Severity: 16, State: 1.
FCB::Open failed: Could not open file E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\MSDBData.mdf for file number 1. OS error: 3(The system cannot find the path specified.).
Error: 5120, Severity: 16, State: 101.
Unable to open the physical file "E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\MSDBData.mdf". Operating system error 3: "3(The system cannot find the path specified.)".
Error: 17207, Severity: 16, State: 1.
FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.
File activation failure. The physical file name "E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\MSDBLog.ldf" may be incorrect.
The resource database build version is 12.00.2000. This is an informational message only. No user action is required.
Starting up database 'model'.我可以清楚地说,我的机器上没有E:\分区。你能帮我修复我现在认为是错误的路径吗?
发布于 2018-02-13 06:12:06
我不知道这是一个bug还是SQL Server 2014通常会出现的问题。对数据库的一些引用将保持如下所示:
E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\MSDBData.mdf所以基本上你必须直接在数据库中修改它们。
以管理员身份运行CMD控制台并访问您的数据库,如下所示:
SQLCMD -S .\或者,如果你有一个实例,就像这样:
SQLCMD –S .\INSTANCENAME使用以下语句将文件重命名为默认位置:
ALTER DATABASE model MODIFY FILE ( NAME = modeldev, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\model.mdf');
ALTER DATABASE model MODIFY FILE ( NAME = modellog, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\modellog.ldf');
ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf');
ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf');
ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\temp.mdf');
ALTER DATABASE tempdb MODIFY FILE ( NAME = templog, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\temp.ldf');
GO在那之后,你的sa用户将保持没有密码(这发生在我身上,不确定它是否总是发生),只需再次登录控制台并手动更改密码:
ALTER LOGIN sa WITH PASSWORD = 'newpassword' UNLOCK当我执行这最后一步时,我遇到了一个问题,因为我的默认登录是使用Windows身份验证配置的,所以说明:
SQLCMD -S .\不起作用,只需添加不带密码的sa用户:
SQLCMD -S .\ -Usa希望能有所帮助。
我在这里找到了解决方案:
发布于 2016-10-19 13:56:10
可能是windows相关问题,没有适当的权限。请在这里查看:http://blog.sqlauthority.com/2016/06/27/sql-server-fcbopen-failed-not-open-file-file-number-2-os-error-5access-denied/
https://stackoverflow.com/questions/40107514
复制相似问题