Click here to Skip to main content
12,697,783 members (26,210 online)
Rate this:
Please Sign up or sign in to vote.
hi am new to sqlserver 2008 unfortunately i clicked detach in tasks of database with project tables developed by some body..... after clicking this detach in tasks of database that is not appearing in object explorer how to get database back to object explorer help me in detail
Posted 25-Sep-12 23:19pm
Updated 25-Sep-12 23:20pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I guess, you are looking for this: MSDN: Attach a Database[^]
Ankur\m/ 26-Sep-12 4:54am
I refreshed the screen before adding the answer, it showed me nothing. Suprisingly the time difference between the answers is about 5 mins. :omg:
Sandeep Mewara 26-Sep-12 9:09am
Not an issue. Have 5 for the same link ;)
Ankur\m/ 26-Sep-12 9:24am
Ah... I guess I forgot the concept of 5 in Q&A. I have not been voting here recently. Let's start with yours.

And thanks! ;)
Sandeep Mewara 26-Sep-12 9:25am

BTW, So does that mean you are back for more answers and time for Q&A now?
Ankur\m/ 26-Sep-12 9:30am
I am not sure. I visit here whenever I get time. This week was good in terms of work load so I was here. I know it won't last very long. :(
Sandeep Mewara 26-Sep-12 9:31am
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

I am considering you are using SQL Server Management Studio.

Connect to the server you want the database in. Right click the database folder and say "Attach". A screen will come up and you will need to provide details like the mdf file of the database.

Get more details here: MSDN - Attach a Database[^]
Sandeep Mewara 26-Sep-12 9:09am
5 for the linked answer. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 26 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100