How can i copy and restore latest .bak file from one server to another server in different locations?

Question

I have a requirement that :

Copy the latest .bak file from Primary server and restore it on Standby server for every 2 days.For this i have to schedule a job and copy the backup and restore it on target server.

Source and Target servers are in different locations.

The .bak file size is approx 20GB.

Thanks,

Naidu.

Answer 1

Is there any drives/nas that both source and target servers can see? If yes then create a backup on the primary server to that drive, then once complete start the restore on the secondary server. 

If there is no drive that both servers can see , then you have to backup on the primary server, copy the backup file to a drive which secondary server can see, for that file transfer you could use robocopy etc and once that's complete start the restore process.

HTH