Restore MSSQL database to another system
Posted on 2011-03-22
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?