Accessing MDF & LDF Files in MS SQL Server 2005

  • Thread starter Thread starter ionlylooklazy
  • Start date Start date
  • Tags Tags
    Mysql
AI Thread Summary
To access and modify parameters in .mdf and .ldf files using Microsoft SQL Server 2005, utilize the SQL Server Management Studio (SSMS). If SSMS is not installed, it can be obtained through the SQL Server 2005 Installer or downloaded as a Community Technology Preview (CTP) version from Microsoft. Once SSMS is set up, connect to your local SQL Server instance, right-click on the Databases folder in the Object Explorer, and select "Attach...". You will need to specify the paths for both the .mdf and .ldf files. After attaching, the database will appear in the Databases folder, allowing for browsing of tables and execution of queries.
ionlylooklazy
Messages
30
Reaction score
0
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
 
Technology news on Phys.org
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.
 

Thread 'Learning Assembly and computer architecture for x86'

Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
View full post »

Thread 'Touch-typing for programmers'

What percentage of programmers have learned to touch type? Have you? Do you think it's important, not just for programming, but for more-than-casual computer users generally? ChatGPT didn't have much on it ("Research indicates that less than 20% of people can touch type fluently, with many relying on the hunt-and-peck method for typing ."). 'Hunt-and-peck method' made me smile. It added, "For programmers, touch typing is a valuable skill that can enhance speed, accuracy, and focus. While...
View full post »

Thread 'Microsoft Technical Interview question'

I had a Microsoft Technical interview this past Friday, the question I was asked was this : How do you find the middle value for a dataset that is too big to fit in RAM? I was not able to figure this out during the interview, but I have been look in this all weekend and I read something online that said it can be done at O(N) using something called the counting sort histogram algorithm ( I did not learn that in my advanced data structures and algorithms class). I have watched some youtube...
View full post »

Similar threads

What does it mean that MySQL is a server application?
Replies
16
Views
3K
How to extract .mdf from .bak in SQL Server 2005
Replies
1
Views
2K
Amateur Dev Q: Creating Front End for SQL Server DB
Replies
18
Views
4K
Why can't there be a Database tool that has the best of everything?
Replies
5
Views
2K
Importing flat files (e.g.) Excel directly into SQL Database
Replies
10
Views
2K
Studying Which Oracle SQL Certification Should You Pursue?
Replies
1
Views
1K
PHP Would like some help understanding website management
Replies
12
Views
2K
Create Distributed Database w/ MySQL, MS SQL, Oracle & PostgreSQL
Replies
6
Views
3K
Learning about Python application deployment - possible recommendations
Replies
7
Views
2K
How has SQL Server not gone the way of the dinosaur?
Replies
3
Views
2K

Hot Threads

Recent Insights

Back
Top