Mysql .mfd & .ldf

  • #1
Hello,

I have never used SQL before and I have a .mdf & a .ldf file and I need to change some parameters. Is there a way to view them like an Access Database?

I have Microsoft SQL Server 2005, but to my knowledge there is no utility included to access these files.

Thanks
 

Answers and Replies

  • #2
-Job-
Science Advisor
1,146
2
Since you have SQL 2005 installed, you can use the Microsoft SQL Server 2005 Management Studio. If you don't have the Management Studio you can install it from the SQL Server 2005 Installer or download a CTP version from Microsoft.

Using the Management Studio, Connect to your local instance of SQL Server, then on the right pane (the object explorer) right-click on the Databases folder and click "Attach...".

Specify the location of your database file (the .mdf) and the log file (the .ldf)
The database will then show up under the databases folder. You'll be able to browse its tables, perform queries, etc.
 

Related Threads on Mysql .mfd & .ldf

  • Last Post
Replies
3
Views
2K
  • Last Post
Replies
16
Views
1K
  • Last Post
Replies
16
Views
1K
  • Last Post
Replies
1
Views
2K
Replies
12
Views
1K
  • Last Post
Replies
6
Views
3K
Replies
21
Views
836
  • Last Post
Replies
2
Views
3K
  • Last Post
Replies
3
Views
665
  • Last Post
Replies
4
Views
2K
Top