database detached

I just detached a sql server express database but not sure where to find it.  where does it  detach to?
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
By default you can get your database mdf and ldf files @ "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data"
Lee SavidgeCommented:
Reattach and right mouse click and choose properties and look at the file locations. Reattach will look in the default location for the databases.

You can find it in the data folder of the sql .
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Lee SavidgeCommented:
That depends on the version of Windows or where they were installed in the first place. It is quickest to reattach, check  properties, detach and then navigate to the files.

IsaacSharePoint Client Side DeveloperAuthor Commented:
I'm using windiws 7.  I need to know where it is located when it was detached so I can reattach.

Anthony PerkinsCommented:
Have you tried the Windows 7 search utility?  I suspect it would take you under 5 minutes to search your computer for anything remotely like *.mdf.

Just a thought.
Aaron ShiloChief Database ArchitectCommented:

just type SP_HELPFILE under the Master database.
your database files are probably under the same path.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.