Step 5. Attach the Database to its new Location

Procedure

  1. Open the SQL Server Enterprise Manager in the new server.
  2. Right mouse-click Databases.
  3. Select All Tasks>Attach Database.

    An Attach Database dialog box opens.

  4. Click the Browser button to the right of the MDF file of database to attach field.
  5. Select an .mdf file in the Browse for Existing File browser.
  6. Click OK.

Results

The database is attached in the new location.