I need to restore a site collection from a SQL DB of a different farm. This SQL DB holds only a single site collection. Both (destination and source) farms are identical except that they are in different domains.
The documentation suggests that restoring SQL DB itself is enough for restore. Is it really the case or would I need to detach the content db before sql db restore and attach it back after restore? If so, why? or is there a standard way of achieving this?
Env: SP 2010 & SQL Server 2008 R2