Follow below steps mentioned:
- Open SQL Management Studio Express and log in to the server to which you want to attach the database.
- In the 'Object Explorer' window, right-click on the 'Databases' folder and select 'Attach...' The 'Attach Databases' window will open.
- inside that window click 'Add...' and then navigate to your .MDF file and click 'OK'.
- Click 'OK' once more to finish attaching the database and you are done.
- The database should be available for use.
Best Regards,
Suresh Sundar