I just came across this Microsoft article on How To: Move Databases Between Computers That Are Running SQL Server.  I haven't had to do this yet, but am foolish if I think it won't happen sometime.