Copying an SQL Server 2005 Database

I have an sql server database on my machine that has tables, data, and stored procs in it. I want to give to put the database and all its data on a different machine. What is the fastest way to do this? I have tried to create a backup file and restore it on the other machine, but that doesnt seem to work. Thanks in advance
Who is Participating?
buddholeConnect With a Mentor Commented:
-Create a db on the new server with the same name, choose the file location and file names you want
- Restore the db with the option "overwrite files" on the Options menu
backup and restore it.
npl77Author Commented:
doesnt do I restore it in detail, maybe im doing something wrong.
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Detach the database from the source server, copy the .mdf and .ldf to the destination server and attach the database there. You might just need to adjust user permission a bit. That should be the fastest way.
npl77Author Commented:
Thanks for such the quick response guys!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.