打开mdf文件时出错 [英] Error while opening a mdf file

问题描述

您好，



我有一个名为sample.pdf的mdf文件。它有一些表格。我试图通过我的电脑打开该文件 - > C drive->程序文件 - > Microsoft SQL server-> MSSQL->

Data-> sample.pdf。



如果我双击那个sample.mdf文件..我收到的错误就像



文件无法打开，因为它被另一个程序使用



如何打开该文件..请帮助我



谢谢你

Hello,

I have an mdf file named sample.pdf. It has some tables. I am trying to open that file through My computer->C drive->program file->Microsoft SQL server->MSSQL->
Data->sample.pdf.

If I double click on that sample.mdf file.. I am getting error like

"The file cannot be opened because it is used by another program"

How can I open that file.. Please help me

Thank You

推荐答案

你需要将mdf文件附加到你的数据库。以下链接显示了如何操作

http://www.c-sharpcorner.com/uploadfile/raj1979/how-to-attach-a-database-in-sql-server-2005/ [ ^ ]

http://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/ [ ^ ]

一旦附加了mdf文件，你就可以在查询窗口中查询表。

You need to attach the mdf file to your database. The below links show how to do it
http://www.c-sharpcorner.com/uploadfile/raj1979/how-to-attach-a-database-in-sql-server-2005/[^]
http://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/[^]
Once you attach the mdf file you can query the tables in the query window.

你不能打开那样的..你可以通过将其附加到服务器数据库

U cant open like that.. U can open that by attaching that to server database

这篇关于打开mdf文件时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！