open existing database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » open existing database

open existing database

Rate Topic

Display Mode

Topic Options

Author

Message

mhh12

Posted Sunday, September 06, 2009 4:05 PM

Grasshopper

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

dbo.benyos

Posted Sunday, September 06, 2009 8:18 PM

SSC-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

mhh12

Posted Tuesday, September 08, 2009 4:32 PM

Grasshopper

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 »

Permissions