Please suggestion program for copy database files.

  • Dear All

    We have problem about copy database we have backup database 11 files and data size is 90 GB every day we must copy backup database from production server to data warehouse server but we use command dos for copy and run with schedule task windows. Some day database could not copy to data warehouse server but log in schedule windows show task complete. Would you like suggest program for copy database files if it freeware it will goods.

  • I would recommend Robocopy or Xcopy cmd utilities.

    Also check this url. http://blogs.msdn.com/b/granth/archive/2010/05/10/how-to-copy-very-large-files-across-a-slow-or-unreliable-network.aspx

  • I second robocopy. You can set the amount of retries and newer versions that are built in the OS have a parameter to setup multi-threading the task.

    Joie Andrew
    "Since 1982"

  • Dear dbasql79 Joie Andrew

    We write batch file with command robocopy run with windows schedule and write log to text file it work 😀 thank you so much.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply