How to Attach a Existing Database to SQL Server?

Add an Existing Database to SQL Server
Hide All Screenshots

 

STEP 1

image Go to Microsoft SQL Server Management Studio > Right Click on Database > Select Attach.

 

image
STEP 2

A new window will be open. Click on Add and browse location of MDF file which you want to add.

 

image

STEP 3

A explorer window will be open. Here select MDF file and click on OK.

 

image
STEP 4
  • Now you will see database file details will be shown. Select database and click on OK.

 

image
STEP 5
  • By exploring Database folder in Object Explorer window, you will see database has been attached.

 

image

Note: If you are not able to attach SQL database to SQL Server or it got corrupted somehow then to recover it use SysTools SQL Recovery which repairs corrupted database accurately and efficiently.

 

Home SysTools FAQs » SQL Server » How to Attach a Database in SQL Server
Loading