Solved

Copy db to another machine on same network.

Posted on 2013-01-29
3
135 Views
Last Modified: 2013-02-02
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
Comment
Question by:hrolsons
3 Comments
 
LVL 22

Expert Comment

by:Steve Wales
ID: 38833460
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
 
LVL 10

Expert Comment

by:sqlservr
ID: 38834346
Options are as below

backup and restore

copy wizard

import /export


dettach and attach
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 38835947
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question