Isaac
asked on
database detached
I just detached a sql server express database but not sure where to find it. where does it detach to?
You can find it in the data folder of the sql .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Lee
Lee
ASKER
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 a thought.
hi
just type SP_HELPFILE under the Master database.
your database files are probably under the same path.
just type SP_HELPFILE under the Master database.
your database files are probably under the same path.
Lee