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 .
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.