Restore with remote SQL

[Anonymous]

How do you restore if your SQL server is remote?  The wizard only lets chose a directory on the local computer where the restore is being performed.  No problem for remote filestore, the location picker allows you to select a location on the network.

Is the idea to restore locally and then move the databases to the remote instance?  Or am I missing something?

[paul.gunn · Accepted solution]

Hi,

When restoring a dataset with a remote database, the system will automatically copy the database backups to the database server and restore them there. This is done via the transfer location configured with the remote sql instance during installation. A similar workflow is done (but in reverse) for backups.

Hope this helps,

Paul