May 13, 2014 at 9:04 am
Hi,
I was wondering if there's a program you guys would recommend in transferring a 400 GB full backup over a WAN. Or how would you transfer the full backup? The only solution I could come up with is splitting the full backup into many smaller files...
We also have Riverbed (http://www.riverbed.com/products/wan-optimization/) appliances between the two sites, but I have enabled SQL compression for the full backup so I wouldn't think it helps much. Perhaps I should attempt to disable SQL compression and compare times during a test transfer...
Any suggestions?
May 13, 2014 at 9:06 am
FTP
May 13, 2014 at 9:48 am
Faster than what? FTP (and its secure cousin, SFTP) has been used for this sort of thing since 1971. Its the usual first choice.
May 13, 2014 at 10:54 am
If you have the file compressed, additional compression is usually not possible. You can either just move the file as is, or try splitting it up and moving the smaller files. But, that carries risk and it may not make it any faster.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2014 at 11:34 am
There are several products available that can help with this kind of data transfer. I used RocketStream before TIBCO bought them and it worked very well.
You have to be very careful with these types of tools though, as they can (and will) take up all available bandwidth. You may be able to get similar results using Robocopy and multi-threading the copy but probably not the same optimization.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 13, 2014 at 11:52 am
I split file with 7 zip to smaller peaces and move them with multiple xcopy commands over rdp session.
This way I am able to continue if connection drops.
May 14, 2014 at 1:14 pm
Thank you for your responses.
Does anyone know of any product that can throttle a file transfer down? I'm looking at a 45 MB bandwidth, but looking to only utilize 20 MB for the full backup file... I've been toying with Robocopy and it's kinda quirky to use (the /ipg switch) and the results I'm getting are either very low (like 5 MB) or utilizes the entire bandwidth.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply