Posted by Jonathan Roberts on 02/16/07 05:20

Greg D. Moore (Strider) wrote:
>> The backup file is located in server A.
>> how should do restore in Server B to catching backup file from serer
>> A??
>>
>
> Use UNCs to refer to the location of the backup.
>

If the servers' drives are not accessible via UNC, FTP can be scripted
and works pretty well. You can create a batch file to compress the
backup and ftp it to the remote server. Your remote server can then
'look' for new backups at a certain interval, uncompress it and restore
it. I believe you could do all of this in batch files if desired or in
SQL jobs. Use whatever you are most familiar with.

[Back to original message]