• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

database detached

I just detached a sql server express database but not sure where to find it.  where does it  detach to?
0
Isaac
Asked:
Isaac
1 Solution
 
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.

Lee
0
 
rajkumartechCommented:
You can find it in the data folder of the sql .
0
 
Alpesh PatelAssistant ConsultantCommented:
By default you can get your database mdf and ldf files @ "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data"
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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.

Lee
0
 
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.

0
 
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.
0
 
Aaron ShiloCommented:
hi

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

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now