Original Post : http://sharepointtaskmaster.blogspot.com/
(March 01, 2012) -Sai Gon- Nice day to all! Today I want to share a simple way to move content database of SharePoint 2012 from SharePoint Database to another.
You know in some cases we do not want to take a lot of time to configure of a Web Application with already a lot of Site Collection and a lot of Sites.
The simple solution is replace the content of the configured database to the destination database. But with SharePoint 2010’s content database, it not allow we restore as normal database.
So we must restore the needed content database to the destination’s SharePoint Database then use Central Admin of SharePoint 2010 to remove the current then add the needed database into the web application the we want to run with.
Now we want the http://HR must use the content database of http://s:100
(Note both servers HR and S are standalone SharePoint Server)
Here are list of steps to move content database from server S to Server HR