Moving a Content Database Between Farms

Below are the five basic steps needed to move a content database from one farm (F1) to another (F2.) This post assumes that you are performing the task manually, not using a migration tool.

1. Detach the content database from F1 using theDismount-SPContentDatabase PowerShell cmdlet .
2. Detach the content database in SSMS for F1.
3. Move the the content database files (.mdf, .ldf, .ndf) to F2.
4. Attach the content database in SSMS for F2.
5. Attach the content database to F2 using the Mount-SPContentDatabase PowerShell cmdlet.

For a higher level of detail, visit