Robocopy to copy files across the network

Question

Hello,

We need to copy very large number of backup files (100 TB) from one server to other server over few days.

We might be schedule through a job to copy .bak files across the server. But, we would like to star the job from where it was finished last days. Let's say if we have copied 5 TB of backup and last file name is bak5 then next day job would start from next files name bak6 and so on.

Anyone can please help?

Answer 1

This is not really a SQL Server question, and would be a better question for the Window forum.

A file copy is all or nothing.   You cannot copy part of a file and then pick up where it left off.

If you are saying you have multiple smaller files, then you can use a "sync" method, using RoboCopy or something else to copy only the files which do not exist on the target.

See:

https://social.technet.microsoft.com/Forums/en-US/bb925c55-a4ab-48a9-b3ae-a1e0c2115dbe/how-to-use-robocopy-to-sync-two-shared-folders-while-user-are-acccesing-it?forum=winserverfiles

Answer 2

How far the servers located ?  I have seen that people put the .BAK file/s on the USB then go to the destination server location , put the usb in and restore locally.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 3

Hi Chickoo79,

Please refer to HOW TO USE ROBOCOPY TO TRANSFER FILES SUPER-FAST OVER THE NETWORK ON WINDOWS 10 to get some useful information.

Hope it could help you.

Best regards,
Cathy Ji

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]