Open the SQL Server Enterprise Manager in the new server.
Right mouse-click Databases.
Select All Tasks>Attach Database.
An Attach Database dialog box opens.
Click the MDF file of database to attach field.
button to the right of theSelect an .mdf file in the Browse for Existing File browser.
Click
.Result: The database is attached in the new location.
Relocate RCO and TADB databases. |