Restore on a different server
I have done a (test) full backup on my local server, and want to restore the database to a different server, that does not contain this database yet.
I select the backup set from the original server (using step 1 of the restore wizard), when I get to step 3, I can't select a different server to restore to. The dropdown list of servers has just one entry, the original server where the backup was performed.
What am I doing wrong?