Link to home
Start Free TrialLog in
Avatar of Isaac
IsaacFlag for United States of America

asked on

database detached

I just detached a sql server express database but not sure where to find it.  where does it  detach to?
Avatar of Lee
Flag of United Kingdom of Great Britain and Northern Ireland image

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 .
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.

Avatar of Isaac


I'm using windiws 7.  I need to know where it is located when it was detached so I can reattach.

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.

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