Any ideas-quickest way, how to transfer a 200GB mdf file from one server to another?
Transfer a 200 GB MDF file
file-transfersql-server-2005
Related Topic
- Problem attaching mdf file in sql server 2008
- File Transfer – Quickest Way to Transfer 55GB of Images to New Server
- Sql – How to attach mdf files from a different SQL Server Install
- Transfer 10 TB of files from USA to UK datacenter
- Ssh – How to avoid stalled scp transfer when tunneling through a gateway over ssh
- Linux – Transfer 15TB of tiny files
Best Answer
Massimo recently asked a question that is somewhat similiar, albeit he was talking about a high-latency network. You don't specify what kind of network it is (gigabit Ethernet LAN, some kind of WAN, etc), but the answer I gave there might give you some ideas, as well.
In particular, the uftp utility that I suggested gave Massimo some pretty decent-looking results on his high-latency WAN. I haven't gotten a chance to test it yet over a gigabit Ethernet LAN but from its description it sounds like it would do a pretty good job of filling up a pipe.
It uses multicast IP to do the copying, so if you only end up needing to copy the file to multiple locations this tool would be a "win" immediately since the file only needs to traverse the network once to be received by an arbitrary number of destinations.