Link to home
Start Free TrialLog in
Avatar of NMHGADM
NMHGADMFlag for United States of America

asked on

Restore MSSQL database to another system

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
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial