You can restore a backup from one server to an existing or new database on a different server using the Restore wizard (in v6.5 and v7+) or the Schedule Restore Jobs wizard (v7+ only).
To restore a backup to a different server using the Restore wizard:
- On step 1 select Browse for backups to restore
from the drop-down list.
- Then specify the server you want to restore the backup to.
- Click Add files
to open the File Browser and browse for backup files to restore. Backups stored on the server you are restoring to are displayed. You can view backups stored on another server by selecting the server from the drop-down list, or clicking Add server
to add another server.
- Proceed through the rest of the wizard as normal.
Further information, including how to restore from a different server using the Schedule Restore Jobs wizard, is available here: http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.1/SBU_BackUpRestoreNetworkShare
Finally, if you would like to evaluate SQL Backup 7, you can download a free trial from our website here: http://www.red-gate.com/products/dba/sql-backup/
I hope that helps.