Before I go down a rabbit hole I need to ask a basic question. Initially we had our Production and Test databases for SDP on the same SQL server. We've since built a new SQL server just for our test products.

I now am unable to take the latest backup from Production and restore it to our Test instance, I assume because the SQL server location is different. Is there a step in the Restore Process that accounts for the databases being on different servers?