Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

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.
0
hrolsons
Asked:
hrolsons
1 Solution
 
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.
0
 
Ramesh Babu VavillaCommented:
Options are as below

backup and restore

copy wizard

import /export


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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now