.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Attach Database

Posted By: Aamrapali Tamgadge     Posted Date: February 18, 2011    Points:2   Category :Sql Server
Hi. How to attach sqlserver database to server can anyone tel me the process throughout.

Author: Pandian             
Posted Date: February 18, 2011     Points: 5   


1. In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance.

2. Right-click Databases, point to Tasks, and then click Attach.

3. In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .mdf file of the database.

i.e: C:\Folder\MDFFileName.mdf

4. Optionally, to specify a different name for the database to attach as, enter the name in the Attach as column of the Attach Databases dialog box.

5. Optionally, change the owner of the database by selecting a different entry in the Owner column.

6. When you are ready to attach the database, click OK.

A newly attached database is not displayed in the Databases node of Object Explorer until the view is refreshed. To refresh the view at any time, click in Object Explorer, and then click Refresh on the View menu.

Source: MSDN


If not I then who, If not now then when

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend