Step 5. Attach the Database to its new Location

  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.

  1. Click the Browser button to the right of the MDF file of database to attach field.

  2. Select an .mdf file in the Browse for Existing File browser.

  1. Click OK.

Result: The database is attached in the new location.

More information

Relocate RCO and TADB databases.