Copy db to another machine on same network.

So, I can see in SSMS my 2 SQL engines each running on seperate machines.  How do I copy(backup) one database from 1 machine to the other.
Who is Participating?
Scott PletcherConnect With a Mentor Senior DBACommented:
Easiest way is to create/use a common drive/folder that both servers can see (share, Windows odbc data source, etc.).  Back up the db to that location on the source machine, then restore from it to the destination machine.
Steve WalesSenior Database AdministratorCommented:
Unless I'm missing something here, the easiest way would be to backup the database on server 1, copy the backup file over to server 2 and restore it to server 2.

You can rename the database and move the files around as a part of the restore process if you need to.
Ramesh Babu VavillaCommented:
Options are as below

backup and restore

copy wizard

import /export

dettach and attach
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.