In general you don't want to try to copy the actual .MDF/.LDF files that represent your SQL Server database(s). If you try to do that you'll hit "file in use" errors such as you're seeing. Instead, use SQL Server's built-in backup function to create separate backup files, and then save those backup files someplace safe.
UPDATE: sorry, I had a bad link in the original post.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov "Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
