Copy Sql-server database

very simple....

Pick a source and destination server.

Select databases to  copy.:- must see this step

 

http://msdn.microsoft.com/en-us/library/ms188664.aspx