?
Solved

Restore MSSQL database to another system

Posted on 2011-03-22
1
Medium Priority
?
404 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 2000 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

588 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