How to Attach and Detach Database on SQL Server

This is a simple way on how to Attach and Detach Database on your SQL Server,
to work with it just follow this few step's:

here where to Detach your Database, just right-click on your database then click
Task, and hit Detach and your done like shown on the image below

and secondly here where you to Attach or get back your database on your SQL
Server,

on you Object Explorer, under your SQL Server name, right click on Database
and hit Attach

a new window or the Attach Database will prompt it to you like shown on the
 image below

just hit the Add button for you to browse your Database on your drives and will
look like this, the Locate Database Files window

just locate your database it can only read a .mdf file not a .ldf file provided by
the SQL server

after selecting your database on your drive, as you can see it will provide the
Selected path with my database path on my drive E then hit the OK button

then after hitting the OK button, the Attach Databases window will prompt like shown
on the image below, listing the Database to be Attach and hit OK button

then your done

then the database will successfully and completely Attached

have a good day

The Hardest Thing to Do is to DO Nothing ^_^

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Tags: Database, SQL Server