我想在SQL SERVER 2008中读取MDF文件（分离MDF文件）时出错 [英] Error when I want to read MDF file (detach MDF file ) in SQL SERVER 2008

问题描述

无法打开物理文件filename.mdf。操作系统错误5：5（访问被拒绝。）。

尝试为文件C：\ lantrial \ App_Data \ hitcount.mdf附加自动命名的数据库失败。存在一个具有相同名称的数据库，或者无法打开指定的文件，或者它位于UNC共享上



这是什么错误为什么我得到错误以及如何为了解决这个问题，请有人告诉我它非常紧急。

Unable to open the physical file "filename.mdf". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file C:\lantrial\App_Data\hitcount.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share

What is this error why i am getting tis error and how to resolve this please somebody tell me its very urgent .

推荐答案

将你的filename.mdf放到以下位置再试一次：



C：\Program Files\Microsoft SQL Server \ MSSQL10_50.MSSQLSERVER \ MSSQL \DATA



如果你遇到任何其他问题我知道。？

我遇到过同样的问题。我会给你另一种方式。





谢谢

Prince Sharma

Put your filename.mdf into follow location and try again:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

If you get any othere issue..let me know.?
I haved faced same issue. I will give you another way.


Thanks
Prince Sharma

这篇关于我想在SQL SERVER 2008中读取MDF文件（分离MDF文件）时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！