Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

open existing database Expand / Collapse
Author
Message
Posted Sunday, September 06, 2009 4:05 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 8:11 AM
Points: 17, Visits: 40
I am trying to use SQL Server Management Studio and bring in an .mdf file that is already listed in
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA

There are a lot of other .mdf files listed there as well. The only one that appears in Object Explorer under
HKRAM\SQLEXPRESS(SQL Server 10.0.1600-HKRAM\my name\)

is Auburn Blue, which I created in MSFT SQL Server Management Studio. The file I want I created in VWD 2008 Express. It also resides in ...My Documents\Visual Studio 2008\WebSites\AuburnSQL\App_Data. Its size is the same but its Date Modified is a couple days more recent.

I can create a new database with the Database\New Database command. Where is the command to open an existing database?

What am I missing?

Mark H.
Post #783548
Posted Sunday, September 06, 2009 8:18 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 09, 2010 2:41 AM
Points: 140, Visits: 1,019
Well, your mistake is by calling it "open". You don't open databases. You access them if they reside on your server.

You first need to bring that DB onto the server you're looking at.

Luckily it is one command below... It is called 'attach'. Just point at the MDF file and wait for a moment.

Good luck


Tal Ben Yosef
www.TalBenYosef.com
(visit my LinkedIn profile)

Post #783586
Posted Tuesday, September 08, 2009 4:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 8:11 AM
Points: 17, Visits: 40
Thank you. It works.
Post #784626
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse