Solved

SQL Server 2008 R2 - can't find .MDF and .LDF files!

Posted on 2013-02-06
2
794 Views
Last Modified: 2013-02-06
Using SQL Server 2008 R2.
I had a local database on my Windows 7 64-bit laptop. I detached it. But, when I search on my hard drive for the MYDATABASE (database name) I should find a MYDATABASE.MDF and a MYDATABASE.LDF file, right?

Mystery! There is none. Because I have already detached it I cannot look at the path in SQL Server Management Studio. Or so I think - is there somewhere in the database management/logs where I can look to find the path? Or is there some other explanation, such as SQL 2008 R2 makes the data files 'hidden' or something?

Thanks for any help.
0
Comment
Question by:hindersaliva
2 Comments
 
LVL 5

Accepted Solution

by:
djbaum earned 500 total points
ID: 38858898
-Open command promt as Admin (press start, type "cmd", right click it invoke as Administrator)
-type "cd \" press enter
-type "dir *.mdf /s" press enter

Hopefully your mdf will be found.
0
 

Author Comment

by:hindersaliva
ID: 38859279
Hey thanks!
It worked.

Hmm ... wonder why searching the folder missed that?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now