Solved

Restore MSSQL database to another system

Posted on 2011-03-22
1
396 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
[X]
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
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
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 is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

688 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