i installed SQL server 2008 r2 and SQL studio manager and how do i open the studio manager and connect the .mdf and .log files to new database?

i have MDF and log file and i would like to create database in studio manager for those files.

before openning Sql studio manager do i have to define something before because i am not able to open studio manager properly to create maybe called attach DB

please advice

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi Nir,
        To address the question in the subject "how do I open SQL server management studio" you should be able to browse to it by going to START>ALL PROGRAMS>MICROSOFT SQL SERVER 2008>Management Studio

If you don't see that in the list, you may not have it installed - I have installed R2 several times where the management studio failed to install during the installation but the rest of the product did.  So check that.  A short way to do it is just hit the Windows Key and in the prompt type SQL it's usually the first option that populates in the search results.

Once you get into the management studio right click on DATABASES in the object explorer on the left hand side and select ATTACH from the dropdown menu.  Click on ADD to browse to your MDF file.  I would take both your MDF and your LOG file and place them in the SQL directories first though.  Usually that is :

D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

The Drive may vary though - my D drive is the normal MDF and my E drive is the Log yours may be different.
HuaMin ChenProblem resolverCommented:
Try to do these in SSMS

Right-click "Databases" > Attach > choose the relevant mdf file
gvilbisAuthor Commented:
I have an existing SQL engine on machine ip,1433 and i am able to Attach new Database as mention above but i would like to create new SQL engine on machine,1433 and to cancel the existing one and then to attach new database which i have the MDF and Log file

what are the step to do that?


Please install new instance of sql server using below link:

1. http://technet.microsoft.com/en-us/library/ms143219(v=sql.100).aspx
2. http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/
3. http://www.codeproject.com/Articles/305113/How-to-Install-SQL-server-2008-on-Windows-7

After installing attach SQL Server database mdf and ldf file to a new instance.

If you want to cancel the existing sql server instance you need to un-install the sql server.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.