Transferring huge amount of data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transferring huge amount of data

I need to transfer a huge amount of data from one server to another server locates across the countries over a narrow bandwidth. 95% of the space is occupied by a single table (85 GB). This table has a Pk.
Also has a Image column. Any suggestions or articles will be greatly appreciated. Thank you. I think, therefore I am
If you can get your hands on SQL LiteSpeed I would use that. It would take it to about 8gb. You could then transfer over ftp, which is still the fastest transfer protocol over the net. If you can’t do that, Zip the backup file up, burn it on a CD, and overnight the CD. It will be faster. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
Ensure the connection between these 2 servers is up and running during this DTS execution. Also ensure there are no issues about disk space on the target server and if possible deploy SIMPLE recovery model. We have a scheduled job every month to import data (size of 30g) from a US server running without any issues. During this DTS execution there are no other jobs scheduled to help package performance. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.