Online Documentation for SQL Administrator for SQL Server

Attach database


Attach Database Wizard allows you to attach an existing database that is made up of one or more files to the instance of Microsoft® SQL Server™ (with SQL Server routines used).

 

This operation is used to attach a database with the specified name and using the specified data files.

 

To run the wizard, select the Tools | AttachDatabase Attach Database... main menu item or click AttachDatabase Attach Database... button on the toolbar.

 

Note: The database must first be detached. Attempting to attach a database that has not been detached will return an error.

 

The wizard consists of the following steps: