Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Restore MSSQL database to another system

Posted on 2011-03-22
1
393 Views
Last Modified: 2012-05-11
I want to restore database A from system 1 to system 2.  Database A exists on both sys 1 & 2 but sys 1 is more current (production).  I have a backup of sys 1 and have copied to sys 2.  I go into Sql 2005 manager and right click on database A, Tasks, Restore, Database.  Restore database window I click "From device" and add the database ".bak" file and it appears in the window under "Select the backup sets to restore".  Now my question -- in that window that shows the backup set to restore under field "Server" it show the system 1 (production) and I am concerned that when I click restore it will restore this backup over my production database on server 1 even though the .bak file is on sys 2 and I am running restore from sql server on sys 2.  Will it restore the database on sys 2 or sys 1?
Thanks
0
Comment
Question by:NMHGADM
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 35192770
it will restore to the database where you have clicked onto to restore to. it will not restore to the system where you have taken the backup unless you are connected to exactly that system
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 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