Solved

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

Posted on 2013-02-06
2
803 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 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