open existing database

  • 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.

  • 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

  • Thank you. It works.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply