Wednesday, 19 December 2012 13:55

how to attach and detach databases in sql server

Written by 
Rate this item
(0 votes)

connecting Asp.net local MDF database files to sql
server management studio express is easy to do.
following are the steps to do so -

step-1: run SQL Server Management studio express.then
right click on the database and u will see attach option
& select it.

step-2: A dialog opened,then click on the Add button.

Step-3: a Dialog opened,then browse and select the mdf file

Step-4: Attached DB file will be seen in dialog box.
click ok then.

If everything ok then u will see the database name
under database folder.

to detach the database just right click on the name of
the database and select detach and proceed.

If u have any questions regarding attach and detach
databases feel free to contact me

Read 1426 times
Super User

Email This email address is being protected from spambots. You need JavaScript enabled to view it.
Login to post comments