Copy database backup files over the network

Hello!
We are using SQLSafe software to backup/compress our databases. We would
like to copy backup files (could be as big as 400GB compressed) to the
different computer within the same network. I know there are tools like
robocopy,xcopy etc. that are suitable for this job. I was wondering if
anybody can share his/her own experience in copying big backup files.
Ideally, we wouldn't like to saturate our network/cpu resources while
copying these files.
Thanks,
IgorHi
I find it best to have the backup software stripe the backup over multiple
files. This enables you to re-start a failed copy without having to re-copy
all 399GB
Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
that they do not copy this file over the production network, affecting normal
queries.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"imarchenko" wrote:
> Hello!
> We are using SQLSafe software to backup/compress our databases. We would
> like to copy backup files (could be as big as 400GB compressed) to the
> different computer within the same network. I know there are tools like
> robocopy,xcopy etc. that are suitable for this job. I was wondering if
> anybody can share his/her own experience in copying big backup files.
> Ideally, we wouldn't like to saturate our network/cpu resources while
> copying these files.
> Thanks,
> Igor
>
>|||Thanks Mike! We are striping backup over multiple files. We just want to
copy backup to the different computer, once it si completed, in the most
efficient way. Thanks for your tip regarding dedicated NIC.
Igor
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:E6EB48F8-4D11-48DD-B2A2-FA1F46334344@.microsoft.com...
> Hi
> I find it best to have the backup software stripe the backup over multiple
> files. This enables you to re-start a failed copy without having to
> re-copy
> all 399GB
> Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
> that they do not copy this file over the production network, affecting
> normal
> queries.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "imarchenko" wrote:
>> Hello!
>> We are using SQLSafe software to backup/compress our databases. We
>> would
>> like to copy backup files (could be as big as 400GB compressed) to the
>> different computer within the same network. I know there are tools like
>> robocopy,xcopy etc. that are suitable for this job. I was wondering if
>> anybody can share his/her own experience in copying big backup files.
>> Ideally, we wouldn't like to saturate our network/cpu resources while
>> copying these files.
>> Thanks,
>> Igor
>>