From memory here, I didnt "title" the article so the SSC crew gave it one 🙂
Fair comment though, I have a few client sites that required 24x7, and attaching and de-attaching is not suitable. To get around this we could:
a) replicate (can be complicated and you need to be 100% sure the schema is identical
b) log ship (very fast)
c) script schema, read-only prod, and populate new server via linked server routines (no keys)
the swap as need be at the business layer.
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"