I didn't understand you, what you mean by "copying database" is to copy its data or copy the files?
If you need to copy its data right click on the database->All tasks->Copy database
If you need to copy its files to move it to another machine; right click on the database->All tasks->detach
then copy physical database files from its location on existing machine then paste them to the another machine (the server in your case) then right click on databases->attach database->select it from its location
Reputation Points: 480
Solved Threads: 276
Postaholic
Offline 2,189 posts
since Aug 2006