Copying an SQL datatbase

Dear Experts,

This must be very simple I just want to know the beast way to do it!

I want to copy the sql 2008 database from my dev PC to my server.

Both the dev PC and Server have sql 2008.

What I usually do is detach database copy to the server and attach.

Regards 1752.
1752Asked:
Who is Participating?
 
Lee SavidgeConnect With a Mentor Commented:
Firstly read this:

http://stackoverflow.com/questions/610113/sql-server-backup-restore-v-s-detach-attach

Secondly, I personally would do a backup and restore.

Backup the database on the main system, zip the backup and copy to the second machine. In SQL Management Studio, create a new target database if needed and then simply restore the database over the top.
0
 
Haresh NikumbhSr. Tech leadCommented:
please refer below article

http://support.microsoft.com/kb/314546
0
 
1752Author Commented:
Thank You.

I will backup and restore.

Regards
1752
0
All Courses

From novice to tech pro — start learning today.