How to move databases between computers that are running SQL Server

Ref http://support.microsoft.com/kb/314546/en-us