Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Please suggestion program for copy database files. Expand / Collapse
Author
Message
Posted Monday, October 22, 2012 12:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 8, 2013 8:21 PM
Points: 3, Visits: 91
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.
Post #1375270
Posted Monday, October 22, 2012 1:06 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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
Post #1375272
Posted Monday, October 22, 2012 2:24 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 709, Visits: 1,419
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"
Post #1375301
Posted Wednesday, October 24, 2012 2:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 8, 2013 8:21 PM
Points: 3, Visits: 91
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.
Post #1376349
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse