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
npl77Asked:
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
0
 
chapmandewCommented:
backup and restore it.
0
 
npl77Author Commented:
doesnt work..how do I restore it in detail, maybe im doing something wrong.
0
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.

 
sm394Commented:
0
 
Yossarian-22Commented:
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.
0
 
npl77Author Commented:
Thanks for such the quick response guys!
0
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.