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

  • 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.



    • Edited by ronsql Friday, April 6, 2012 3:20 PM
    Friday, April 6, 2012 2:25 PM


  • 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.


    • Proposed as answer by Maggie Luo Tuesday, April 17, 2012 4:05 PM
    • Marked as answer by Maggie Luo Thursday, April 26, 2012 6:57 AM
    Friday, April 6, 2012 4:54 PM