SQL Server Performance

Transferring huge amount of data

Discussion in 'SQL Server DTS-Related Questions' started by ravilobo, Aug 25, 2004.

  1. ravilobo New Member

    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
  2. derrickleggett New Member

    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 />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
  3. satya Moderator

    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.

Share This Page